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.
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 ...