Method-Based Query Examples (LINQ to DataSet)

This section provides LINQ to DataSet programming examples in method-based query syntax that use the standard query operators. The DataSet used in these examples is populated by using the FillDataSet method, which is specified in Loading Data Into a DataSet. For more information, see Standard Query Operators Overview.

In This Section

Projection
The examples in this topic demonstrate how to use the Select and SelectMany methods to query a DataSet.

Partitioning
The examples in this topic demonstrate how to use the Skip and Take methods to query a DataSet and partition the results.

Ordering
The examples in this topic demonstrate how to use the OrderBy, OrderByDescending, Reverse, and ThenByDescending methods to query a DataSet and order the results.

Set Operators
The examples in this topic demonstrate how to use the Distinct, Except, Intersect, and Union operators to perform value-based comparison operations on sets of data rows.

Conversion Operators
The examples in this topic demonstrate how to use the ToArray, ToDictionary, and ToList methods to immediately execute a query expression.

Element Operators
The examples in this topic demonstrate how to use the First and ElementAt methods to get DataRow elements from a DataSet.

Aggregate Operators
The examples in this topic demonstrate how to use the Average, Count, Max, Min, and Sum methods to query a DataSet and aggregate data.

Join
The examples in this topic demonstrate how to use the GroupJoin and Join methods to query a DataSet.

See Also

Query Expression Examples
DataSet-Specific Operator Examples
LINQ to DataSet Examples