Queries (Visual Basic)

Visual Basic enables you to create Language-Integrated Query (LINQ) expressions in your code.

In This Section

Aggregate Clause
Describes the Aggregate clause, which applies one or more aggregate functions to a collection.

Distinct Clause
Describes the Distinct clause, which restricts the values of the current range variable to eliminate duplicate values in query results.

From Clause
Describes the From clause, which specifies a collection and a range variable for a query.

Group By Clause
Describes the Group By clause, which groups the elements of a query result and can be used to apply aggregate functions to each group.

Group Join Clause
Describes the Group Join clause, which combines two collections into a single hierarchical collection.

Join Clause
Describes the Join clause, which combines two collections into a single collection.

Let Clause
Describes the Let clause, which computes a value and assigns it to a new variable in the query.

Order By Clause
Describes the Order By clause, which specifies the sort order for columns in a query.

Select Clause
Describes the Select clause, which declares a set of range variables for a query.

Skip Clause
Describes the Skip clause, which bypasses a specified number of elements in a collection and then returns the remaining elements.

Skip While Clause
Describes the Skip While clause, which bypasses elements in a collection as long as a specified condition is true and then returns the remaining elements.

Take Clause
Describes the Take clause, which returns a specified number of contiguous elements from the start of a collection.

Take While Clause
Describes the Take While clause, which includes elements in a collection as long as a specified condition is true and bypasses the remaining elements.

Where Clause
Describes the Where clause, which specifies a filtering condition for a query.

See also