Query Expression Examples (LINQ to DataSet)

This section provides LINQ to DataSet programming examples in query expression 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.

The examples in the following topics use the following using/Imports statements:

Option Explicit On 

Imports System
Imports System.Linq
Imports System.Linq.Expressions
Imports System.Collections.Generic
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.Common
Imports System.Globalization

using System;
using System.Linq;
using System.Linq.Expressions;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Globalization;

In This Section

• Projection Query Expression Syntax Examples (LINQ to DataSet)
  The examples in this topic demonstrate how to use the Select and SelectMany methods to query a DataSet.

• Restriction Query Expression Syntax Examples (LINQ to DataSet)
  The examples in this topic demonstrate how to use the Where method to query a DataSet.

• Partitioning Query Expression Syntax Examples (LINQ to DataSet)
  The examples in this topic demonstrate how to use the Skip<TSource> and Take<TSource> methods to query a DataSet and partition the results.

• Ordering Query Expression Syntax Examples (LINQ to DataSet)
  The examples in this topic demonstrate how to use the OrderBy, OrderByDescending, Reverse<TSource>, and ThenByDescending methods to query a DataSet and order the results.

• Element Operators Query Expression Syntax Examples (LINQ to DataSet)
  The examples in this topic demonstrate how to use the First and ElementAt<TSource> methods to get DataRow elements from a DataSet.

• Aggregate Operators Query Expression Syntax Examples (LINQ to DataSet)
  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 Operators Query Expression Syntax Examples (LINQ to DataSet)
  The examples in this topic demonstrate how to use the GroupJoin and Join methods to query a DataSet.

See Also

Concepts

Method-Based Query Examples (LINQ to DataSet)

DataSet-Specific Operator Examples (LINQ to DataSet)

Other Resources

LINQ to DataSet Examples