Linq to SQL
Linq is a great .NET technology for accessing data across a variety of data sources. Visual Studio and Linq make the task of manipulating data in SQL Server super easy in your .NET program. I highly recommend it!
A word of caution though. Make sure to re-generate your Linq to SQL classes upon ANY change to the database tables, otherwise you will start getting error messages that don’t always make sense. One way to avoid the problem is to use the SQLMetal tool as a pre-build command to automatically re-generate Linq classes.