Programming in c# + sql database where to get training material?

Question

SQL

4th course, zaochka, the session is burning, I ask friends to help with advice.
I am a web programmer familiar with mysql (via phpmyadmin), php, js, as 3.0. etc.
It is required to pass a course paper in C #, later I will write a diploma on it. Unfortunately, the deadlines are very tight + work puts pressure on time.
And so I am faced with the task of creating a working system for working with a database through an application (windows forms). I have a licensed version of VS 2012(RUS) and 2008(ENG) and figured out the code quickly, not a problem of many tutorials. But about how to connect from the application, at least like some kind of database, not a word in Russian. I am looking for material on this subject C # + sql.
There are no problems with the syntax of queries and the language itself, but there is a catastrophic lack of knowledge about the language itself.

Answer 1

I agree with the previous speaker, now there are a lot of technologies that allow you to abstract from connections, for example, the entity framework, which allows you to interact with c # code with mssql
, you can see the materials here - Entity Framework Guide , there are examples for winforms
But you can also through pure ado.net to do, but there you have to work with connections at a lower level and additionally write a lot of code