Additional DataSet Capabilities

In the previous chapter, I provided numerous examples querying DataTable objects that would naturally come from typical DataSets in a real-world development environment. For the sake of simplicity though, I programmatically created the DataTable objects using a static array declaration. However, there is more to DataSet queries than just creating DataTable objects from statically declared arrays.

Also, the examples in the previous chapter were all performed on untyped DataSets. Sometimes, you may find you have a need to query a typed DataSet. LINQ to DataSet can do that too.

In this chapter, I address these issues and show you how to make the most of LINQ to DataSet. I begin with a discussion of querying typed DataSets with LINQ to DataSet. Then, since I pointed out that there is more to querying DataSets than programmatically creating DataTable objects, I follow up with a real-world example of querying a database with LINQ to DataSet.