Queryable Class

Definition

Namespace:: System.Linq

Assemblies:: System.Core.dll, System.Linq.Queryable.dll

Assemblies:: netstandard.dll, System.Linq.Queryable.dll

Assembly:: System.Linq.Queryable.dll

Assembly:: System.Core.dll

Assembly:: netstandard.dll

Source:: Queryable.cs

Source:: Queryable.cs

Source:: Queryable.cs

Source:: Queryable.cs

Source:: Queryable.cs

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Provides a set of static (Shared in Visual Basic) methods for querying data structures that implement IQueryable.

public ref class Queryable abstract sealed

public static class Queryable

type Queryable = class

Public Module Queryable

Inheritance: Object
Queryable

Remarks

The set of methods declared in the Queryable class provides an implementation of the standard query operators for querying data sources that implement IQueryable. The standard query operators are general purpose methods that follow the LINQ pattern and enable you to express traversal, filter, and projection operations over data in any .NET-based programming language.

The majority of the methods in this class are defined as extension methods that extend the IQueryable type. This means they can be called like an instance method on any object that implements IQueryable. These methods that extend IQueryable do not perform any querying directly. Instead, their functionality is to build an Expression object, which is an expression tree that represents the cumulative query. The methods then pass the new expression tree to either the Execute(Expression) method or the CreateQuery(Expression) method of the input IQueryable. The method that is called depends on whether the Queryable method returns a singleton value, in which case Execute(Expression) is called, or has enumerable results, in which case CreateQuery(Expression) is called.

The actual query execution on the target data is performed by a class that implements IQueryable. The expectation of any IQueryable implementation is that the result of executing an expression tree that was constructed by a Queryable standard query operator method is equivalent to the result of calling the corresponding method in the Enumerable class, if the data source were an IEnumerable.

In addition to the standard query operator methods that operate on IQueryable objects, this class also contains a method, AsQueryable, which types IEnumerable objects as IQueryable objects.

Methods

Name	Description
Aggregate(IQueryable, TAccumulate, Expression>, Expression>)	Applies an accumulator function over a sequence. The specified seed value is used as the initial accumulator value, and the specified function is used to select the result value.
Aggregate(IQueryable, TAccumulate, Expression>)	Applies an accumulator function over a sequence. The specified seed value is used as the initial accumulator value.
Aggregate(IQueryable, Expression>)	Applies an accumulator function over a sequence.
AggregateBy(IQueryable, Expression>, Expression>, Expression>, IEqualityComparer)	Applies an accumulator function over a sequence, grouping results by key.
AggregateBy(IQueryable, Expression>, TAccumulate, Expression>, IEqualityComparer)	Applies an accumulator function over a sequence, grouping results by key.
All(IQueryable, Expression>)	Determines whether all the elements of a sequence satisfy a condition.
Any(IQueryable, Expression>)	Determines whether any element of a sequence satisfies a condition.
Any(IQueryable)	Determines whether a sequence contains any elements.
Append(IQueryable, TSource)	Returns a new queryable sequence that contains the elements from `source` plus the specified `element` appended at the end.
AsQueryable(IEnumerable)	Converts an IEnumerable to an IQueryable.
AsQueryable(IEnumerable)	Converts a generic IEnumerable to a generic IQueryable.
Average(IQueryable)	Computes the average of a sequence of Decimal values.
Average(IQueryable)	Computes the average of a sequence of Double values.
Average(IQueryable)	Computes the average of a sequence of Int32 values.
Average(IQueryable)	Computes the average of a sequence of Int64 values.
Average(IQueryable>)	Computes the average of a sequence of nullable Decimal values.
Average(IQueryable>)	Computes the average of a sequence of nullable Double values.
Average(IQueryable>)	Computes the average of a sequence of nullable Int32 values.
Average(IQueryable>)	Computes the average of a sequence of nullable Int64 values.
Average(IQueryable>)	Computes the average of a sequence of nullable Single values.
Average(IQueryable)	Computes the average of a sequence of Single values.
Average(IQueryable, Expression>)	Computes the average of a sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.
Average(IQueryable, Expression>)	Computes the average of a sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.
Average(IQueryable, Expression>)	Computes the average of a sequence of Int32 values that is obtained by invoking a projection function on each element of the input sequence.
Average(IQueryable, Expression>)	Computes the average of a sequence of Int64 values that is obtained by invoking a projection function on each element of the input sequence.
Average(IQueryable, Expression>>)	Computes the average of a sequence of nullable Decimal values that is obtained by invoking a projection function on each element of the input sequence.
Average(IQueryable, Expression>>)	Computes the average of a sequence of nullable Double values that is obtained by invoking a projection function on each element of the input sequence.
Average(IQueryable, Expression>>)	Computes the average of a sequence of nullable Int32 values that is obtained by invoking a projection function on each element of the input sequence.
Average(IQueryable, Expression>>)	Computes the average of a sequence of nullable Int64 values that is obtained by invoking a projection function on each element of the input sequence.
Average(IQueryable, Expression>>)	Computes the average of a sequence of nullable Single values that is obtained by invoking a projection function on each element of the input sequence.
Average(IQueryable, Expression>)	Computes the average of a sequence of Single values that is obtained by invoking a projection function on each element of the input sequence.
Cast(IQueryable)	Converts the elements of an IQueryable to the specified type.
Chunk(IQueryable, Int32)	Split the elements of a sequence into chunks of size at most `size`.
Concat(IQueryable, IEnumerable)	Concatenates two sequences.
Contains(IQueryable, TSource, IEqualityComparer)	Determines whether a sequence contains a specified element by using a specified IEqualityComparer.
Contains(IQueryable, TSource)	Determines whether a sequence contains a specified element by using the default equality comparer.
Count(IQueryable, Expression>)	Returns the number of elements in the specified sequence that satisfies a condition.
Count(IQueryable)	Returns the number of elements in a sequence.
CountBy(IQueryable, Expression>, IEqualityComparer)	Returns the count of each element from a sequence according to a specified key selector function.
DefaultIfEmpty(IQueryable, TSource)	Returns the elements of the specified sequence or the specified value in a singleton collection if the sequence is empty.
DefaultIfEmpty(IQueryable)	Returns the elements of the specified sequence or the type parameter's default value in a singleton collection if the sequence is empty.
Distinct(IQueryable, IEqualityComparer)	Returns distinct elements from a sequence by using a specified IEqualityComparer to compare values.
Distinct(IQueryable)	Returns distinct elements from a sequence by using the default equality comparer to compare values.
DistinctBy(IQueryable, Expression>, IEqualityComparer)	Returns distinct elements from a sequence according to a specified key selector function.
DistinctBy(IQueryable, Expression>)	Returns distinct elements from a sequence according to a specified key selector function.
ElementAt(IQueryable, Index)	Returns the element at a specified index in a sequence.
ElementAt(IQueryable, Int32)	Returns the element at a specified index in a sequence.
ElementAtOrDefault(IQueryable, Index)	Returns the element at a specified index in a sequence or a default value if the index is out of range.
ElementAtOrDefault(IQueryable, Int32)	Returns the element at a specified index in a sequence or a default value if the index is out of range.
Except(IQueryable, IEnumerable, IEqualityComparer)	Produces the set difference of two sequences by using the specified IEqualityComparer to compare values.
Except(IQueryable, IEnumerable)	Produces the set difference of two sequences by using the default equality comparer to compare values.
ExceptBy(IQueryable, IEnumerable, Expression>, IEqualityComparer)	Produces the set difference of two sequences according to a specified key selector function.
ExceptBy(IQueryable, IEnumerable, Expression>)	Produces the set difference of two sequences according to a specified key selector function.
First(IQueryable, Expression>)	Returns the first element of a sequence that satisfies a specified condition.
First(IQueryable)	Returns the first element of a sequence.
FirstOrDefault(IQueryable, Expression>, TSource)	Returns the first element of the sequence that satisfies a condition or a default value if no such element is found.
FirstOrDefault(IQueryable, Expression>)	Returns the first element of a sequence that satisfies a specified condition or a default value if no such element is found.
FirstOrDefault(IQueryable, TSource)	Returns the first element of a sequence, or a default value if the sequence contains no elements.
FirstOrDefault(IQueryable)	Returns the first element of a sequence, or a default value if the sequence contains no elements.
FullJoin(IQueryable, IEnumerable, Expression>, Expression>, Expression>, IEqualityComparer)
FullJoin(IQueryable, IEnumerable, Expression>, Expression>, IEqualityComparer)
GroupBy(IQueryable, Expression>, Expression>, Expression,TResult>>, IEqualityComparer)	Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. Keys are compared by using a specified comparer and the elements of each group are projected by using a specified function.
GroupBy(IQueryable, Expression>, Expression>, Expression,TResult>>)	Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. The elements of each group are projected by using a specified function.
GroupBy(IQueryable, Expression>, Expression>, IEqualityComparer)	Groups the elements of a sequence and projects the elements for each group by using a specified function. Key values are compared by using a specified comparer.
GroupBy(IQueryable, Expression>, Expression>)	Groups the elements of a sequence according to a specified key selector function and projects the elements for each group by using a specified function.
GroupBy(IQueryable, Expression>, Expression,TResult>>, IEqualityComparer)	Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. Keys are compared by using a specified comparer.
GroupBy(IQueryable, Expression>, Expression,TResult>>)	Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key.
GroupBy(IQueryable, Expression>, IEqualityComparer)	Groups the elements of a sequence according to a specified key selector function and compares the keys by using a specified comparer.
GroupBy(IQueryable, Expression>)	Groups the elements of a sequence according to a specified key selector function.
GroupJoin(IQueryable, IEnumerable, Expression>, Expression>, Expression,TResult>>, IEqualityComparer)	Correlates the elements of two sequences based on key equality and groups the results. A specified IEqualityComparer is used to compare keys.
GroupJoin(IQueryable, IEnumerable, Expression>, Expression>, Expression,TResult>>)	Correlates the elements of two sequences based on key equality and groups the results. The default equality comparer is used to compare keys.
GroupJoin(IQueryable, IEnumerable, Expression>, Expression>, IEqualityComparer)
Index(IQueryable)	Return index and the associated item.
Intersect(IQueryable, IEnumerable, IEqualityComparer)	Produces the set intersection of two sequences by using the specified IEqualityComparer to compare values.
Intersect(IQueryable, IEnumerable)	Produces the set intersection of two sequences by using the default equality comparer to compare values.
IntersectBy(IQueryable, IEnumerable, Expression>, IEqualityComparer)	Produces the set intersection of two sequences according to a specified key selector function.
IntersectBy(IQueryable, IEnumerable, Expression>)	Produces the set intersection of two sequences according to a specified key selector function.
Join(IQueryable, IEnumerable, Expression>, Expression>, Expression>, IEqualityComparer)	Correlates the elements of two sequences based on matching keys. A specified IEqualityComparer is used to compare keys.
Join(IQueryable, IEnumerable, Expression>, Expression>, Expression>)	Correlates the elements of two sequences based on matching keys. The default equality comparer is used to compare keys.
Join(IQueryable, IEnumerable, Expression>, Expression>, IEqualityComparer)
Last(IQueryable, Expression>)	Returns the last element of a sequence that satisfies a specified condition.
Last(IQueryable)	Returns the last element in a sequence.
LastOrDefault(IQueryable, Expression>, TSource)	Returns the last element of a sequence that satisfies a condition or a default value if no such element is found.
LastOrDefault(IQueryable, Expression>)	Returns the last element of a sequence that satisfies a condition or a default value if no such element is found.
LastOrDefault(IQueryable, TSource)	Returns the last element of a sequence, or a default value if the sequence contains no elements.
LastOrDefault(IQueryable)	Returns the last element in a sequence, or a default value if the sequence contains no elements.
LeftJoin(IQueryable, IEnumerable, Expression>, Expression>, Expression>, IEqualityComparer)	Correlates the elements of two sequences based on matching keys. A specified IEqualityComparer is used to compare keys.
LeftJoin(IQueryable, IEnumerable, Expression>, Expression>, Expression>)	Correlates the elements of two sequences based on matching keys. The default equality comparer is used to compare keys.
LeftJoin(IQueryable, IEnumerable, Expression>, Expression>, IEqualityComparer)
LongCount(IQueryable, Expression>)	Returns an Int64 that represents the number of elements in a sequence that satisfy a condition.
LongCount(IQueryable)	Returns an Int64 that represents the total number of elements in a sequence.
Max(IQueryable, Expression>)	Invokes a projection function on each element of a generic IQueryable and returns the maximum resulting value.
Max(IQueryable, IComparer)	Returns the maximum value in a generic IQueryable.
Max(IQueryable)	Returns the maximum value in a generic IQueryable.
MaxBy(IQueryable, Expression>, IComparer)	Returns the maximum value in a generic IQueryable according to a specified key selector function.
MaxBy(IQueryable, Expression>, IComparer)	Obsolete. Returns the maximum value in a generic IQueryable according to a specified key selector function.
MaxBy(IQueryable, Expression>)	Returns the maximum value in a generic IQueryable according to a specified key selector function.
Min(IQueryable, Expression>)	Invokes a projection function on each element of a generic IQueryable and returns the minimum resulting value.
Min(IQueryable, IComparer)	Returns the minimum value in a generic IQueryable.
Min(IQueryable)	Returns the minimum value of a generic IQueryable.
MinBy(IQueryable, Expression>, IComparer)	Returns the minimum value in a generic IQueryable according to a specified key selector function.
MinBy(IQueryable, Expression>, IComparer)	Obsolete. Returns the minimum value in a generic IQueryable according to a specified key selector function.
MinBy(IQueryable, Expression>)	Returns the minimum value in a generic IQueryable according to a specified key selector function.
OfType(IQueryable)	Filters the elements of an IQueryable based on a specified type.
Order(IQueryable, IComparer)	Sorts the elements of a sequence in ascending order.
Order(IQueryable)	Sorts the elements of a sequence in ascending order.
OrderBy(IQueryable, Expression>, IComparer)	Sorts the elements of a sequence in ascending order by using a specified comparer.
OrderBy(IQueryable, Expression>)	Sorts the elements of a sequence in ascending order according to a key.
OrderByDescending(IQueryable, Expression>, IComparer)	Sorts the elements of a sequence in descending order by using a specified comparer.
OrderByDescending(IQueryable, Expression>)	Sorts the elements of a sequence in descending order according to a key.
OrderDescending(IQueryable, IComparer)	Sorts the elements of a sequence in descending order.
OrderDescending(IQueryable)	Sorts the elements of a sequence in descending order.
Prepend(IQueryable, TSource)	Returns a new queryable sequence that contains the elements from `source` plus the specified `element` prepended at the beginning.
Reverse(IQueryable)	Inverts the order of the elements in a sequence.
RightJoin(IQueryable, IEnumerable, Expression>, Expression>, Expression>, IEqualityComparer)	Correlates the elements of two sequences based on matching keys. A specified IEqualityComparer is used to compare keys.
RightJoin(IQueryable, IEnumerable, Expression>, Expression>, Expression>)	Correlates the elements of two sequences based on matching keys. The default equality comparer is used to compare keys.
RightJoin(IQueryable, IEnumerable, Expression>, Expression>, IEqualityComparer)
Select(IQueryable, Expression>)	Projects each element of a sequence into a new form by incorporating the element's index.
Select(IQueryable, Expression>)	Projects each element of a sequence into a new form.
SelectMany(IQueryable, Expression>>, Expression>)	Projects each element of a sequence to an IEnumerable and invokes a result selector function on each element therein. The resulting values from each intermediate sequence are combined into a single, one-dimensional sequence and returned.
SelectMany(IQueryable, Expression>>, Expression>)	Projects each element of a sequence to an IEnumerable that incorporates the index of the source element that produced it. A result selector function is invoked on each element of each intermediate sequence, and the resulting values are combined into a single, one-dimensional sequence and returned.
SelectMany(IQueryable, Expression>>)	Projects each element of a sequence to an IEnumerable and combines the resulting sequences into one sequence.
SelectMany(IQueryable, Expression>>)	Projects each element of a sequence to an IEnumerable and combines the resulting sequences into one sequence. The index of each source element is used in the projected form of that element.
SequenceEqual(IQueryable, IEnumerable, IEqualityComparer)	Determines whether two sequences are equal by using a specified IEqualityComparer to compare elements.
SequenceEqual(IQueryable, IEnumerable)	Determines whether two sequences are equal by using the default equality comparer to compare elements.
Shuffle(IQueryable)
Single(IQueryable, Expression>)	Returns the only element of a sequence that satisfies a specified condition, and throws an exception if more than one such element exists.
Single(IQueryable)	Returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence.
SingleOrDefault(IQueryable, Expression>, TSource)	Returns the only element of a sequence that satisfies a specified condition or a default value if no such element exists; this method throws an exception if more than one element satisfies the condition.
SingleOrDefault(IQueryable, Expression>)	Returns the only element of a sequence that satisfies a specified condition or a default value if no such element exists; this method throws an exception if more than one element satisfies the condition.
SingleOrDefault(IQueryable, TSource)	Returns the only element of a sequence, or a default value if the sequence is empty; this method throws an exception if there is more than one element in the sequence.
SingleOrDefault(IQueryable)	Returns the only element of a sequence, or a default value if the sequence is empty; this method throws an exception if there is more than one element in the sequence.
Skip(IQueryable, Int32)	Bypasses a specified number of elements in a sequence and then returns the remaining elements.
SkipLast(IQueryable, Int32)	Returns a new queryable sequence that contains the elements from `source` with the last `count` elements of the source queryable sequence omitted.
SkipWhile(IQueryable, Expression>)	Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements.
SkipWhile(IQueryable, Expression>)	Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements. The element's index is used in the logic of the predicate function.
Sum(IQueryable)	Computes the sum of a sequence of Decimal values.
Sum(IQueryable)	Computes the sum of a sequence of Double values.
Sum(IQueryable)	Computes the sum of a sequence of Int32 values.
Sum(IQueryable)	Computes the sum of a sequence of Int64 values.
Sum(IQueryable>)	Computes the sum of a sequence of nullable Decimal values.
Sum(IQueryable>)	Computes the sum of a sequence of nullable Double values.
Sum(IQueryable>)	Computes the sum of a sequence of nullable Int32 values.
Sum(IQueryable>)	Computes the sum of a sequence of nullable Int64 values.
Sum(IQueryable>)	Computes the sum of a sequence of nullable Single values.
Sum(IQueryable)	Computes the sum of a sequence of Single values.
Sum(IQueryable, Expression>)	Computes the sum of the sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.
Sum(IQueryable, Expression>)	Computes the sum of the sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.
Sum(IQueryable, Expression>)	Computes the sum of the sequence of Int32 values that is obtained by invoking a projection function on each element of the input sequence.
Sum(IQueryable, Expression>)	Computes the sum of the sequence of Int64 values that is obtained by invoking a projection function on each element of the input sequence.
Sum(IQueryable, Expression>>)	Computes the sum of the sequence of nullable Decimal values that is obtained by invoking a projection function on each element of the input sequence.
Sum(IQueryable, Expression>>)	Computes the sum of the sequence of nullable Double values that is obtained by invoking a projection function on each element of the input sequence.
Sum(IQueryable, Expression>>)	Computes the sum of the sequence of nullable Int32 values that is obtained by invoking a projection function on each element of the input sequence.
Sum(IQueryable, Expression>>)	Computes the sum of the sequence of nullable Int64 values that is obtained by invoking a projection function on each element of the input sequence.
Sum(IQueryable, Expression>>)	Computes the sum of the sequence of nullable Single values that is obtained by invoking a projection function on each element of the input sequence.
Sum(IQueryable, Expression>)	Computes the sum of the sequence of Single values that is obtained by invoking a projection function on each element of the input sequence.
Take(IQueryable, Int32)	Returns a specified number of contiguous elements from the start of a sequence.
Take(IQueryable, Range)	Returns a specified range of contiguous elements from a sequence.
TakeLast(IQueryable, Int32)	Returns a new queryable sequence that contains the last `count` elements from `source`.
TakeWhile(IQueryable, Expression>)	Returns elements from a sequence as long as a specified condition is true.
TakeWhile(IQueryable, Expression>)	Returns elements from a sequence as long as a specified condition is true. The element's index is used in the logic of the predicate function.
ThenBy(IOrderedQueryable, Expression>, IComparer)	Performs a subsequent ordering of the elements in a sequence in ascending order by using a specified comparer.
ThenBy(IOrderedQueryable, Expression>)	Performs a subsequent ordering of the elements in a sequence in ascending order according to a key.
ThenByDescending(IOrderedQueryable, Expression>, IComparer)	Performs a subsequent ordering of the elements in a sequence in descending order by using a specified comparer.
ThenByDescending(IOrderedQueryable, Expression>)	Performs a subsequent ordering of the elements in a sequence in descending order, according to a key.
Union(IQueryable, IEnumerable, IEqualityComparer)	Produces the set union of two sequences by using a specified IEqualityComparer.
Union(IQueryable, IEnumerable)	Produces the set union of two sequences by using the default equality comparer.
UnionBy(IQueryable, IEnumerable, Expression>, IEqualityComparer)	Produces the set union of two sequences according to a specified key selector function.
UnionBy(IQueryable, IEnumerable, Expression>)	Produces the set union of two sequences according to a specified key selector function.
Where(IQueryable, Expression>)	Filters a sequence of values based on a predicate.
Where(IQueryable, Expression>)	Filters a sequence of values based on a predicate. Each element's index is used in the logic of the predicate function.
Zip(IQueryable, IEnumerable, Expression>)	Merges two sequences by using the specified predicate function.
Zip(IQueryable, IEnumerable, IEnumerable)	Produces a sequence of tuples with elements from the three specified sequences.
Zip(IQueryable, IEnumerable)	Produces a sequence of tuples with elements from the two specified sequences.

Applies to

Feedback

Was this page helpful?