Queryable Methods

The Queryable type exposes the following members.

  Name Description
Public method Static member Aggregate<TSource>(IQueryable<TSource>, Expression<Func<TSource, TSource, TSource>>) Applies an accumulator function over a sequence.
Public method Static member Aggregate<TSource, TAccumulate>(IQueryable<TSource>, TAccumulate, Expression<Func<TAccumulate, TSource, TAccumulate>>) Applies an accumulator function over a sequence. The specified seed value is used as the initial accumulator value.
Public method Static member Aggregate<TSource, TAccumulate, TResult>(IQueryable<TSource>, TAccumulate, Expression<Func<TAccumulate, TSource, TAccumulate>>, Expression<Func<TAccumulate, TResult>>) 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.
Public method Static member All<TSource> Determines whether all the elements of a sequence satisfy a condition.
Public method Static member Any<TSource>(IQueryable<TSource>) Determines whether a sequence contains any elements.
Public method Static member Any<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) Determines whether any element of a sequence satisfies a condition.
Public method Static member AsQueryable(IEnumerable) Converts an IEnumerable to an IQueryable.
Public method Static member AsQueryable<TElement>(IEnumerable<TElement>) Converts a generic IEnumerable<T> to a generic IQueryable<T>.
Public method Static member Average(IQueryable<Decimal>) Computes the average of a sequence of Decimal values.
Public method Static member Average(IQueryable<Nullable<Decimal>>) Computes the average of a sequence of nullable Decimal values.
Public method Static member Average(IQueryable<Double>) Computes the average of a sequence of Double values.
Public method Static member Average(IQueryable<Nullable<Double>>) Computes the average of a sequence of nullable Double values.
Public method Static member Average(IQueryable<Int32>) Computes the average of a sequence of Int32 values.
Public method Static member Average(IQueryable<Nullable<Int32>>) Computes the average of a sequence of nullable Int32 values.
Public method Static member Average(IQueryable<Int64>) Computes the average of a sequence of Int64 values.
Public method Static member Average(IQueryable<Nullable<Int64>>) Computes the average of a sequence of nullable Int64 values.
Public method Static member Average(IQueryable<Nullable<Single>>) Computes the average of a sequence of nullable Single values.
Public method Static member Average(IQueryable<Single>) Computes the average of a sequence of Single values.
Public method Static member Average<TSource>(IQueryable<TSource>, Expression<Func<TSource, Decimal>>) Computes the average of a sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.
Public method Static member Average<TSource>(IQueryable<TSource>, Expression<Func<TSource, Double>>) Computes the average of a sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.
Public method Static member Average<TSource>(IQueryable<TSource>, Expression<Func<TSource, Int32>>) Computes the average of a sequence of Int32 values that is obtained by invoking a projection function on each element of the input sequence.
Public method Static member Average<TSource>(IQueryable<TSource>, Expression<Func<TSource, Int64>>) Computes the average of a sequence of Int64 values that is obtained by invoking a projection function on each element of the input sequence.
Public method Static member Average<TSource>(IQueryable<TSource>, Expression<Func<TSource, Nullable<Decimal>>>) 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.
Public method Static member Average<TSource>(IQueryable<TSource>, Expression<Func<TSource, Nullable<Double>>>) 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.
Public method Static member Average<TSource>(IQueryable<TSource>, Expression<Func<TSource, Nullable<Int32>>>) 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.
Public method Static member Average<TSource>(IQueryable<TSource>, Expression<Func<TSource, Nullable<Int64>>>) 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.
Public method Static member Average<TSource>(IQueryable<TSource>, Expression<Func<TSource, Nullable<Single>>>) 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.
Public method Static member Average<TSource>(IQueryable<TSource>, Expression<Func<TSource, Single>>) Computes the average of a sequence of Single values that is obtained by invoking a projection function on each element of the input sequence.
Public method Static member Cast<TResult> Converts the elements of an IQueryable to the specified type.
Public method Static member Concat<TSource> Concatenates two sequences.
Public method Static member Contains<TSource>(IQueryable<TSource>, TSource) Determines whether a sequence contains a specified element by using the default equality comparer.
Public method Static member Contains<TSource>(IQueryable<TSource>, TSource, IEqualityComparer<TSource>) Determines whether a sequence contains a specified element by using a specified IEqualityComparer<T>.
Public method Static member Count<TSource>(IQueryable<TSource>) Returns the number of elements in a sequence.
Public method Static member Count<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) Returns the number of elements in the specified sequence that satisfies a condition.
Public method Static member DefaultIfEmpty<TSource>(IQueryable<TSource>) Returns the elements of the specified sequence or the type parameter's default value in a singleton collection if the sequence is empty.
Public method Static member DefaultIfEmpty<TSource>(IQueryable<TSource>, TSource) Returns the elements of the specified sequence or the specified value in a singleton collection if the sequence is empty.
Public method Static member Distinct<TSource>(IQueryable<TSource>) Returns distinct elements from a sequence by using the default equality comparer to compare values.
Public method Static member Distinct<TSource>(IQueryable<TSource>, IEqualityComparer<TSource>) Returns distinct elements from a sequence by using a specified IEqualityComparer<T> to compare values.
Public method Static member ElementAt<TSource> Returns the element at a specified index in a sequence.
Public method Static member ElementAtOrDefault<TSource> Returns the element at a specified index in a sequence or a default value if the index is out of range.
Public method Static member Except<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Produces the set difference of two sequences by using the default equality comparer to compare values.
Public method Static member Except<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Produces the set difference of two sequences by using the specified IEqualityComparer<T> to compare values.
Public method Static member First<TSource>(IQueryable<TSource>) Returns the first element of a sequence.
Public method Static member First<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) Returns the first element of a sequence that satisfies a specified condition.
Public method Static member FirstOrDefault<TSource>(IQueryable<TSource>) Returns the first element of a sequence, or a default value if the sequence contains no elements.
Public method Static member FirstOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) Returns the first element of a sequence that satisfies a specified condition or a default value if no such element is found.
Public method Static member GroupBy<TSource, TKey>(IQueryable<TSource>, Expression<Func<TSource, TKey>>) Groups the elements of a sequence according to a specified key selector function.
Public method Static member GroupBy<TSource, TKey>(IQueryable<TSource>, Expression<Func<TSource, TKey>>, IEqualityComparer<TKey>) Groups the elements of a sequence according to a specified key selector function and compares the keys by using a specified comparer.
Public method Static member GroupBy<TSource, TKey, TElement>(IQueryable<TSource>, Expression<Func<TSource, TKey>>, Expression<Func<TSource, TElement>>) 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.
Public method Static member GroupBy<TSource, TKey, TResult>(IQueryable<TSource>, Expression<Func<TSource, TKey>>, Expression<Func<TKey, IEnumerable<TSource>, 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.
Public method Static member GroupBy<TSource, TKey, TElement>(IQueryable<TSource>, Expression<Func<TSource, TKey>>, Expression<Func<TSource, TElement>>, IEqualityComparer<TKey>) 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.
Public method Static member GroupBy<TSource, TKey, TResult>(IQueryable<TSource>, Expression<Func<TSource, TKey>>, Expression<Func<TKey, IEnumerable<TSource>, TResult>>, IEqualityComparer<TKey>) 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.
Public method Static member GroupBy<TSource, TKey, TElement, TResult>(IQueryable<TSource>, Expression<Func<TSource, TKey>>, Expression<Func<TSource, TElement>>, Expression<Func<TKey, IEnumerable<TElement>, 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.
Public method Static member GroupBy<TSource, TKey, TElement, TResult>(IQueryable<TSource>, Expression<Func<TSource, TKey>>, Expression<Func<TSource, TElement>>, Expression<Func<TKey, IEnumerable<TElement>, TResult>>, IEqualityComparer<TKey>) 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.
Public method Static member GroupJoin<TOuter, TInner, TKey, TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter, TKey>>, Expression<Func<TInner, TKey>>, Expression<Func<TOuter, IEnumerable<TInner>, TResult>>) Correlates the elements of two sequences based on key equality and groups the results. The default equality comparer is used to compare keys.
Public method Static member GroupJoin<TOuter, TInner, TKey, TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter, TKey>>, Expression<Func<TInner, TKey>>, Expression<Func<TOuter, IEnumerable<TInner>, TResult>>, IEqualityComparer<TKey>) Correlates the elements of two sequences based on key equality and groups the results. A specified IEqualityComparer<T> is used to compare keys.
Public method Static member Intersect<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Produces the set intersection of two sequences by using the default equality comparer to compare values.
Public method Static member Intersect<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Produces the set intersection of two sequences by using the specified IEqualityComparer<T> to compare values.
Public method Static member Join<TOuter, TInner, TKey, TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter, TKey>>, Expression<Func<TInner, TKey>>, Expression<Func<TOuter, TInner, TResult>>) Correlates the elements of two sequences based on matching keys. The default equality comparer is used to compare keys.
Public method Static member Join<TOuter, TInner, TKey, TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter, TKey>>, Expression<Func<TInner, TKey>>, Expression<Func<TOuter, TInner, TResult>>, IEqualityComparer<TKey>) Correlates the elements of two sequences based on matching keys. A specified IEqualityComparer<T> is used to compare keys.
Public method Static member Last<TSource>(IQueryable<TSource>) Returns the last element in a sequence.
Public method Static member Last<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) Returns the last element of a sequence that satisfies a specified condition.
Public method Static member LastOrDefault<TSource>(IQueryable<TSource>) Returns the last element in a sequence, or a default value if the sequence contains no elements.
Public method Static member LastOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) Returns the last element of a sequence that satisfies a condition or a default value if no such element is found.
Public method Static member LongCount<TSource>(IQueryable<TSource>) Returns an Int64 that represents the total number of elements in a sequence.
Public method Static member LongCount<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) Returns an Int64 that represents the number of elements in a sequence that satisfy a condition.
Public method Static member Max<TSource>(IQueryable<TSource>) Returns the maximum value in a generic IQueryable<T>.
Public method Static member Max<TSource, TResult>(IQueryable<TSource>, Expression<Func<TSource, TResult>>) Invokes a projection function on each element of a generic IQueryable<T> and returns the maximum resulting value.
Public method Static member Min<TSource>(IQueryable<TSource>) Returns the minimum value of a generic IQueryable<T>.
Public method Static member Min<TSource, TResult>(IQueryable<TSource>, Expression<Func<TSource, TResult>>) Invokes a projection function on each element of a generic IQueryable<T> and returns the minimum resulting value.
Public method Static member OfType<TResult> Filters the elements of an IQueryable based on a specified type.
Public method Static member OrderBy<TSource, TKey>(IQueryable<TSource>, Expression<Func<TSource, TKey>>) Sorts the elements of a sequence in ascending order according to a key.
Public method Static member OrderBy<TSource, TKey>(IQueryable<TSource>, Expression<Func<TSource, TKey>>, IComparer<TKey>) Sorts the elements of a sequence in ascending order by using a specified comparer.
Public method Static member OrderByDescending<TSource, TKey>(IQueryable<TSource>, Expression<Func<TSource, TKey>>) Sorts the elements of a sequence in descending order according to a key.
Public method Static member OrderByDescending<TSource, TKey>(IQueryable<TSource>, Expression<Func<TSource, TKey>>, IComparer<TKey>) Sorts the elements of a sequence in descending order by using a specified comparer.
Public method Static member Reverse<TSource> Inverts the order of the elements in a sequence.
Public method Static member Select<TSource, TResult>(IQueryable<TSource>, Expression<Func<TSource, TResult>>) Projects each element of a sequence into a new form.
Public method Static member Select<TSource, TResult>(IQueryable<TSource>, Expression<Func<TSource, Int32, TResult>>) Projects each element of a sequence into a new form by incorporating the element's index.
Public method Static member SelectMany<TSource, TResult>(IQueryable<TSource>, Expression<Func<TSource, IEnumerable<TResult>>>) Projects each element of a sequence to an IEnumerable<T> and combines the resulting sequences into one sequence.
Public method Static member SelectMany<TSource, TResult>(IQueryable<TSource>, Expression<Func<TSource, Int32, IEnumerable<TResult>>>) Projects each element of a sequence to an IEnumerable<T> and combines the resulting sequences into one sequence. The index of each source element is used in the projected form of that element.
Public method Static member SelectMany<TSource, TCollection, TResult>(IQueryable<TSource>, Expression<Func<TSource, IEnumerable<TCollection>>>, Expression<Func<TSource, TCollection, TResult>>) Projects each element of a sequence to an IEnumerable<T> 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.
Public method Static member SelectMany<TSource, TCollection, TResult>(IQueryable<TSource>, Expression<Func<TSource, Int32, IEnumerable<TCollection>>>, Expression<Func<TSource, TCollection, TResult>>) Projects each element of a sequence to an IEnumerable<T> 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.
Public method Static member SequenceEqual<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Determines whether two sequences are equal by using the default equality comparer to compare elements.
Public method Static member SequenceEqual<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Determines whether two sequences are equal by using a specified IEqualityComparer<T> to compare elements.
Public method Static member Single<TSource>(IQueryable<TSource>) Returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence.
Public method Static member Single<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) Returns the only element of a sequence that satisfies a specified condition, and throws an exception if more than one such element exists.
Public method Static member SingleOrDefault<TSource>(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.
Public method Static member SingleOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) 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.
Public method Static member Skip<TSource> Bypasses a specified number of elements in a sequence and then returns the remaining elements.
Public method Static member SkipWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements.
Public method Static member SkipWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource, Int32, Boolean>>) 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.
Public method Static member Sum(IQueryable<Decimal>) Computes the sum of a sequence of Decimal values.
Public method Static member Sum(IQueryable<Nullable<Decimal>>) Computes the sum of a sequence of nullable Decimal values.
Public method Static member Sum(IQueryable<Double>) Computes the sum of a sequence of Double values.
Public method Static member Sum(IQueryable<Nullable<Double>>) Computes the sum of a sequence of nullable Double values.
Public method Static member Sum(IQueryable<Int32>) Computes the sum of a sequence of Int32 values.
Public method Static member Sum(IQueryable<Nullable<Int32>>) Computes the sum of a sequence of nullable Int32 values.
Public method Static member Sum(IQueryable<Int64>) Computes the sum of a sequence of Int64 values.
Public method Static member Sum(IQueryable<Nullable<Int64>>) Computes the sum of a sequence of nullable Int64 values.
Public method Static member Sum(IQueryable<Nullable<Single>>) Computes the sum of a sequence of nullable Single values.
Public method Static member Sum(IQueryable<Single>) Computes the sum of a sequence of Single values.
Public method Static member Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource, Decimal>>) Computes the sum of the sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.
Public method Static member Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource, Double>>) Computes the sum of the sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.
Public method Static member Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource, Int32>>) Computes the sum of the sequence of Int32 values that is obtained by invoking a projection function on each element of the input sequence.
Public method Static member Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource, Int64>>) Computes the sum of the sequence of Int64 values that is obtained by invoking a projection function on each element of the input sequence.
Public method Static member Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource, Nullable<Decimal>>>) 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.
Public method Static member Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource, Nullable<Double>>>) 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.
Public method Static member Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource, Nullable<Int32>>>) 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.
Public method Static member Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource, Nullable<Int64>>>) 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.
Public method Static member Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource, Nullable<Single>>>) 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.
Public method Static member Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource, Single>>) Computes the sum of the sequence of Single values that is obtained by invoking a projection function on each element of the input sequence.
Public method Static member Take<TSource> Returns a specified number of contiguous elements from the start of a sequence.
Public method Static member TakeWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) Returns elements from a sequence as long as a specified condition is true.
Public method Static member TakeWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource, Int32, Boolean>>) 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.
Public method Static member ThenBy<TSource, TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource, TKey>>) Performs a subsequent ordering of the elements in a sequence in ascending order according to a key.
Public method Static member ThenBy<TSource, TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource, TKey>>, IComparer<TKey>) Performs a subsequent ordering of the elements in a sequence in ascending order by using a specified comparer.
Public method Static member ThenByDescending<TSource, TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource, TKey>>) Performs a subsequent ordering of the elements in a sequence in descending order, according to a key.
Public method Static member ThenByDescending<TSource, TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource, TKey>>, IComparer<TKey>) Performs a subsequent ordering of the elements in a sequence in descending order by using a specified comparer.
Public method Static member Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Produces the set union of two sequences by using the default equality comparer.
Public method Static member Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Produces the set union of two sequences by using a specified IEqualityComparer<T>.
Public method Static member Where<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) Filters a sequence of values based on a predicate.
Public method Static member Where<TSource>(IQueryable<TSource>, Expression<Func<TSource, Int32, Boolean>>) Filters a sequence of values based on a predicate. Each element's index is used in the logic of the predicate function.
Public method Static member Zip<TFirst, TSecond, TResult> Merges two sequences by using the specified predicate function.
Top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft