Querying DataSets (LINQ to DataSet)

After a DataSet object has been populated with data, you can begin querying it. Formulating queries with LINQ to DataSet is similar to using Language-Integrated Query (LINQ) against other LINQ-enabled data sources. Remember, however, that when you use LINQ queries over a DataSet object you are querying an enumeration of DataRow objects, instead of an enumeration of a custom type. This means that you can use any of the members of the DataRow class in your LINQ queries. This lets you to create rich, complex queries.

As with other implementations of LINQ, you can create LINQ to DataSet queries in two different forms: query expression syntax and method-based query syntax. For more information about these two forms, see Getting Started with LINQ. You can use query expression syntax or method-based query syntax to perform queries against single tables in a DataSet, against multiple tables in a DataSet, or against tables in a typed DataSet.

In This Section

Single-Table Queries
Describes how to perform single-table queries.

Cross-Table Queries
Describes how to perform cross-table queries.

Querying Typed DataSets
Describes how to query typed DataSet objects.

See Also

LINQ to DataSet Examples
Loading Data Into a DataSet