Chapter 31. LINQ to DataSet

The last of our chapters on LINQ relates to the System.Data.DataSet class, which can be used to create an in-memory cache of data from a database and which can be used as the data source for LINQ queries.

The DataSet class is part of ADO.NET—just like the Entity Framework that we saw in the previous chapter. ADO.NET is big; it allows you to access a wide range of data sources in a wide range of ways. In this chapter, we'll be looking at working with databases more directly than with the Entity Framework. We won't be using data models or C# objects that represent tables and rows. In fact, if you have been waiting for a chance to break out your SQL skills, then this is the chapter for you.

ADO.NET supports all the major ...

Get Introducing Visual C# 2010 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.