MSDN has ADO.NET Code Examples https://msdn.microsoft.com/en-us/library/dw70f090(v=vs.110).aspx to start with.

First look at SqlClient namespace which is ADO.Net specific toolset for MS SQL DBs.

Having already done some Db related projects you most probably worked with DataSets, which is the next step otherwise.

Them you may wish to proceed with EF and LINQ.