There are tones of examples that are very helpful. I would certainly look into the Entity Framework technology. But, I strongly urge you to learn T-Sql (I started learning T-SQL here www.trainingspot.com and used Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes ISBN-13: 978-0672325670 and slowly promoted myself to: Microsoft SQL Server® 2008 T-SQL Fundamentals (PRO-Developer) ISBN-13: 978-8178531045.
Try to learn the old school way of (Connection, Command, Parameter .....etc etc) ADO.NET 2.0, just in case you inherit an old project (HAPPENED TO ME!!!).