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 (C#) or Standard Query Operators Overview (Visual Basic).
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.