elrasho, I was in a similar position to you 6 years ago (wow how time flies)
I wanted to move from a support role to a development role which meant changing companies for me.
I too went from a position of knowing nothing about the .net framework, asp.net, sql etc and was overwhelmed by the language and all that sat around it.
Luckily the lead developer at the time picked up on this after throwing me in at the deep end and asking me to convert an application to .net 2.0 from 1.0 and seeing the blank look on my face kind of said it all.
So to get that basic fundamental of the language down and re-energize lost programming concepts I went with the classic Dummies book at first just to use more as a reference material to understand the basic syntax, loop structures, object-orientated programming etc.
Because I was working with a lot of winform apps I then got this book
Windows Forms Programming in C#, Chris Sells
http://www.amazon.co.uk/Windows-For...6208/ref=sr_1_1?ie=UTF8&qid=1363678280&sr=8-1
This gave me more of a grounding of the c# language and allowed me to develop on the core concepts that I had learnt.
In order to build on these pieces of information I developed a little winforms apps to help me understand the language but actually use it in my day to day work life. (it's still used now - although when I look back at the code it makes me shudder
![Stick Out Tongue :p :p](/styles/default/xenforo/vbSmilies/Normal/tongue.gif)
)
After several months I then moved more into the web arena which meant learning another language (HTML) which looking back on it was a step too far as I was still trying to get to grips with the basics of working with C#.
Role on several years and I have finally started the move from web forms to MVC and all the new technologies that go with it.
My best piece of advice would be master the basics of the language and basic design principles before moving on to look at more advanced features/ interesting features of the language. Due to my scattergun approach to learning the C# language it is only within the last 12 months that I have started to really review my own development training and it highlighted my failings in a number of key areas such as Object Orientated Design, Generics, Linq, Unit Testing and a few others.
These are books that I got to help me with some of that learning
Dependency Injection in .Net (has been invaluable in helping me think about designing code)
http://www.amazon.co.uk/gp/product/...&pf_rd_t=101&pf_rd_p=317828027&pf_rd_i=468294
The art of unit testing (not really used this in anger yet but I will be on my next big project)
http://www.amazon.co.uk/gp/product/...&pf_rd_t=101&pf_rd_p=317828027&pf_rd_i=468294
HTML5 Programming for asp.net developers (am using this as a refresher and update for the web side of things and to link in with new MVC learning)
http://www.amazon.co.uk/HTML5-Progr...r_1_19?s=books&ie=UTF8&qid=1353375270&sr=1-19
HTML & CSS: Design and build websites (really visual and works with no programming knowledge)
http://www.amazon.co.uk/HTML-CSS-De...=sr_1_1?s=books&ie=UTF8&qid=1353375634&sr=1-1
I personally found the easiest way to get started was find something that needed a software solution and then develop an application for it. This then allows you to get used to thinking like a programmer and then helps to build on any background reading.
Once you have then completed this first application then take a step back and look at the code again and if you see improvements add them in and test. If you look back and don't seem to understand what is going on then it is time rewrite and build it in a more structured way building on those first principles. (If you have existing developers then it may be worth getting peer review and see if they will help in your development)
I hope this hasn't bored you too much but I wanted to show I guess that the swap from support to development can be achieved with no prior background it just takes time.
As a side note it may be worth looking at plural sight as a source of training material if you have a subscription via work (we recently started using it and it has some good courses on basic software fundamentals/design patterns).