Summary: So Many Tools, So Little Time

Although we explained at the beginning of this chapter that the number and variety of data access technologies available to Microsoft developers is great, you still might not have been prepared for just how many choices (and subchoices) there are. And the number of questions is greater still! Should you use ORM technology at all? If so, should it be LINQ to SQL or the Entity Framework? If the latter, should you use LINQ to Entities, EntityClient, or Object Services to query the models? Is conventional ADO.NET dead? Are the days of typed DataSets numbered? And even if you are sticking with ADO.NET, should you start using LINQ to DataSet exclusively instead of staying with direct ADO.NET SQL queries?

The reality ...

Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.