DbQuery<TResult> Class

Reference

Definition

Namespace:: System.Data.Entity.Infrastructure

Assembly:: EntityFramework.dll

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.

Represents a LINQ to Entities query against a DbContext.

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Naming", "CA1710:IdentifiersShouldHaveCorrectSuffix", Justification="Name is intentional")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Naming", "CA1709:IdentifiersShouldBeCasedCorrectly", Justification="Casing is intentional")]
public class DbQuery<TResult> : System.Collections.Generic.IEnumerable<TResult>, System.ComponentModel.IListSource, System.Data.Entity.Infrastructure.IDbAsyncEnumerable<TResult>, System.Linq.IOrderedQueryable<TResult>, System.Linq.IQueryable<TResult>

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Naming", "CA1710:IdentifiersShouldHaveCorrectSuffix", Justification="Name is intentional")]
[System.Diagnostics.DebuggerDisplay("{DebuggerDisplay()}")]
public class DbQuery<TResult> : System.Collections.Generic.IEnumerable<TResult>, System.ComponentModel.IListSource, System.Data.Entity.Infrastructure.IDbAsyncEnumerable<TResult>, System.Linq.IOrderedQueryable<TResult>, System.Linq.IQueryable<TResult>

type DbQuery<'Result> = class
    interface IOrderedQueryable<'Result>
    interface IQueryable<'Result>
    interface seq<'Result>
    interface IOrderedQueryable
    interface IQueryable
    interface IEnumerable
    interface IListSource
    interface IDbAsyncEnumerable<'Result>
    interface IDbAsyncEnumerable

Public Class DbQuery(Of TResult)
Implements IDbAsyncEnumerable(Of TResult), IEnumerable(Of TResult), IListSource, IOrderedQueryable(Of TResult), IQueryable(Of TResult)

Type Parameters

TResult

The type of entity to query for.

Inheritance: Object
DbQuery<TResult>

Derived: System.Data.Entity.DbSet<TEntity>

Attributes: SuppressMessageAttribute DebuggerDisplayAttribute

Implements: IEnumerable<T> IEnumerable<TResult> IEnumerable IListSource IDbAsyncEnumerable IDbAsyncEnumerable<TResult> IOrderedQueryable IOrderedQueryable<TResult> IQueryable IQueryable<T> IQueryable<TResult>

Properties

Sql	Gets a String representation of the underlying query.

Methods

AsNoTracking()	Returns a new query where the entities returned will not be cached in the DbContext.
AsStreaming()	Obsolete. Returns a new query that will stream the results instead of buffering.
Equals(Object)	Determines whether the specified object is equal to the current object.
GetHashCode()	Serves as the default hash function.
GetType()	Gets the Type of the current instance.
Include(String)	Specifies the related objects to include in the query results.
ToString()	Returns a String representation of the underlying query.

Operators

Implicit(DbQuery<TResult> to DbQuery)

Returns a new instance of the non-generic DbQuery class for this query.

Explicit Interface Implementations

IDbAsyncEnumerable.GetAsyncEnumerator()	Returns an IDbAsyncEnumerator which when enumerated will execute the query against the database.
IDbAsyncEnumerable<TResult>.GetAsyncEnumerator()	Returns an IDbAsyncEnumerator<T> which when enumerated will execute the query against the database.
IEnumerable.GetEnumerator()	Returns an IEnumerator<T> which when enumerated will execute the query against the database.
IEnumerable<TResult>.GetEnumerator()	Returns an IEnumerator<T> which when enumerated will execute the query against the database.
IListSource.ContainsListCollection	Returns `false`.
IListSource.GetList()	Throws an exception indicating that binding directly to a store query is not supported. Instead populate a DbSet with data, for example by using the Load extension method, and then bind to local data. For WPF bind to DbSet.Local. For Windows Forms bind to DbSet.Local.ToBindingList().
IQueryable.ElementType	The IQueryable element type.
IQueryable.Expression	The IQueryable LINQ Expression.
IQueryable.Provider	The IQueryable provider.

Extension Methods

AsNoTracking<T>(IQueryable<T>)	Returns a new query where the entities returned will not be cached in the DbContext or ObjectContext. This method works by calling the AsNoTracking method of the underlying query object. If the underlying query object does not have a AsNoTracking method, then calling this method will have no affect.
Include<T>(IQueryable<T>, String)
Include<T,TProperty>(IQueryable<T>, Expression<Func<T,TProperty>>)
AllAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)	Asynchronously determines whether all the elements of a sequence satisfy a condition.
AllAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken)	Asynchronously determines whether all the elements of a sequence satisfy a condition.
AnyAsync<TSource>(IQueryable<TSource>)	Asynchronously determines whether a sequence contains any elements.
AnyAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)	Asynchronously determines whether any element of a sequence satisfies a condition.
AnyAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken)	Asynchronously determines whether any element of a sequence satisfies a condition.
AnyAsync<TSource>(IQueryable<TSource>, CancellationToken)	Asynchronously determines whether a sequence contains any elements.
AsNoTracking<T>(IQueryable<T>)	Returns a new query where the entities returned will not be cached in the DbContext or ObjectContext. This method works by calling the AsNoTracking method of the underlying query object. If the underlying query object does not have an AsNoTracking method, then calling this method will have no affect.
AsStreaming<T>(IQueryable<T>)	Obsolete. Returns a new query that will stream the results instead of buffering. This method works by calling the AsStreaming method of the underlying query object. If the underlying query object does not have an AsStreaming method, then calling this method will have no affect.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>)	Asynchronously computes the average of a sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>, CancellationToken)	Asynchronously computes the average of a sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)	Asynchronously computes the average of a sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>, CancellationToken)	Asynchronously computes the average of a sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>)	Asynchronously computes the average of a sequence of Int32 values that is obtained by invoking a projection function on each element of the input sequence.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>, CancellationToken)	Asynchronously computes the average of a sequence of Int32 values that is obtained by invoking a projection function on each element of the input sequence.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>)	Asynchronously computes the average of a sequence of Int64 values that is obtained by invoking a projection function on each element of the input sequence.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>, CancellationToken)	Asynchronously computes the average of a sequence of Int64 values that is obtained by invoking a projection function on each element of the input sequence.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>)	Asynchronously 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.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>, CancellationToken)	Asynchronously 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.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>)	Asynchronously 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.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>, CancellationToken)	Asynchronously 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.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>)	Asynchronously 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.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>, CancellationToken)	Asynchronously 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.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>)	Asynchronously 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.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>, CancellationToken)	Asynchronously 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.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>)	Asynchronously 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.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>, CancellationToken)	Asynchronously 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.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>)	Asynchronously computes the average of a sequence of Single values that is obtained by invoking a projection function on each element of the input sequence.
AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>, CancellationToken)	Asynchronously computes the average of a sequence of Single values that is obtained by invoking a projection function on each element of the input sequence.
ContainsAsync<TSource>(IQueryable<TSource>, TSource)	Asynchronously determines whether a sequence contains a specified element by using the default equality comparer.
ContainsAsync<TSource>(IQueryable<TSource>, TSource, CancellationToken)	Asynchronously determines whether a sequence contains a specified element by using the default equality comparer.
CountAsync<TSource>(IQueryable<TSource>)	Asynchronously returns the number of elements in a sequence.
CountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)	Asynchronously returns the number of elements in a sequence that satisfy a condition.
CountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken)	Asynchronously returns the number of elements in a sequence that satisfy a condition.
CountAsync<TSource>(IQueryable<TSource>, CancellationToken)	Asynchronously returns the number of elements in a sequence.
FirstAsync<TSource>(IQueryable<TSource>)	Asynchronously returns the first element of a sequence.
FirstAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)	Asynchronously returns the first element of a sequence that satisfies a specified condition.
FirstAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken)	Asynchronously returns the first element of a sequence that satisfies a specified condition.
FirstAsync<TSource>(IQueryable<TSource>, CancellationToken)	Asynchronously returns the first element of a sequence.
FirstOrDefaultAsync<TSource>(IQueryable<TSource>)	Asynchronously returns the first element of a sequence, or a default value if the sequence contains no elements.
FirstOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)	Asynchronously returns the first element of a sequence that satisfies a specified condition or a default value if no such element is found.
FirstOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken)	Asynchronously returns the first element of a sequence that satisfies a specified condition or a default value if no such element is found.
FirstOrDefaultAsync<TSource>(IQueryable<TSource>, CancellationToken)	Asynchronously returns the first element of a sequence, or a default value if the sequence contains no elements.
ForEachAsync<T>(IQueryable<T>, Action<T>)	Asynchronously enumerates the query results and performs the specified action on each element.
ForEachAsync<T>(IQueryable<T>, Action<T>, CancellationToken)	Asynchronously enumerates the query results and performs the specified action on each element.
Include<T>(IQueryable<T>, String)	Specifies the related objects to include in the query results.
Include<T,TProperty>(IQueryable<T>, Expression<Func<T,TProperty>>)	Specifies the related objects to include in the query results.
LongCountAsync<TSource>(IQueryable<TSource>)	Asynchronously returns an Int64 that represents the total number of elements in a sequence.
LongCountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)	Asynchronously returns an Int64 that represents the number of elements in a sequence that satisfy a condition.
LongCountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken)	Asynchronously returns an Int64 that represents the number of elements in a sequence that satisfy a condition.
LongCountAsync<TSource>(IQueryable<TSource>, CancellationToken)	Asynchronously returns an Int64 that represents the total number of elements in a sequence.
MaxAsync<TSource>(IQueryable<TSource>)	Asynchronously returns the maximum value of a sequence.
MaxAsync<TSource>(IQueryable<TSource>, CancellationToken)	Asynchronously returns the maximum value of a sequence.
MaxAsync<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>)	Asynchronously invokes a projection function on each element of a sequence and returns the maximum resulting value.
MaxAsync<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>, CancellationToken)	Asynchronously invokes a projection function on each element of a sequence and returns the maximum resulting value.
MinAsync<TSource>(IQueryable<TSource>)	Asynchronously returns the minimum value of a sequence.
MinAsync<TSource>(IQueryable<TSource>, CancellationToken)	Asynchronously returns the minimum value of a sequence.
MinAsync<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>)	Asynchronously invokes a projection function on each element of a sequence and returns the minimum resulting value.
MinAsync<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>, CancellationToken)	Asynchronously invokes a projection function on each element of a sequence and returns the minimum resulting value.
SingleAsync<TSource>(IQueryable<TSource>)	Asynchronously returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence.
SingleAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)	Asynchronously returns the only element of a sequence that satisfies a specified condition, and throws an exception if more than one such element exists.
SingleAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken)	Asynchronously returns the only element of a sequence that satisfies a specified condition, and throws an exception if more than one such element exists.
SingleAsync<TSource>(IQueryable<TSource>, CancellationToken)	Asynchronously returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence.
SingleOrDefaultAsync<TSource>(IQueryable<TSource>)	Asynchronously 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.
SingleOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)	Asynchronously 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.
SingleOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken)	Asynchronously 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.
SingleOrDefaultAsync<TSource>(IQueryable<TSource>, CancellationToken)	Asynchronously 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<TSource>(IQueryable<TSource>, Expression<Func<Int32>>)	Bypasses a specified number of elements in a sequence and then returns the remaining elements.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>)	Asynchronously computes the sum of the sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>, CancellationToken)	Asynchronously computes the sum of the sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)	Asynchronously computes the sum of the sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>, CancellationToken)	Asynchronously computes the sum of the sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>)	Asynchronously computes the sum of the sequence of Int32 values that is obtained by invoking a projection function on each element of the input sequence.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>, CancellationToken)	Asynchronously computes the sum of the sequence of Int32 values that is obtained by invoking a projection function on each element of the input sequence.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>)	Asynchronously computes the sum of the sequence of Int64 values that is obtained by invoking a projection function on each element of the input sequence.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>, CancellationToken)	Asynchronously computes the sum of the sequence of Int64 values that is obtained by invoking a projection function on each element of the input sequence.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>)	Asynchronously 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.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>, CancellationToken)	Asynchronously 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.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>)	Asynchronously 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.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>, CancellationToken)	Asynchronously 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.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>)	Asynchronously 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.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>, CancellationToken)	Asynchronously 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.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>)	Asynchronously 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.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>, CancellationToken)	Asynchronously 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.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>)	Asynchronously 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.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>, CancellationToken)	Asynchronously 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.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>)	Asynchronously computes the sum of the sequence of Single values that is obtained by invoking a projection function on each element of the input sequence.
SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>, CancellationToken)	Asynchronously 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<TSource>(IQueryable<TSource>, Expression<Func<Int32>>)	Returns a specified number of contiguous elements from the start of a sequence.
ToArrayAsync<TSource>(IQueryable<TSource>)	Creates an array from an IQueryable<T> by enumerating it asynchronously.
ToArrayAsync<TSource>(IQueryable<TSource>, CancellationToken)	Creates an array from an IQueryable<T> by enumerating it asynchronously.
ToDictionaryAsync<TSource,TKey>(IQueryable<TSource>, Func<TSource,TKey>)	Creates a Dictionary<TKey,TValue> from an IQueryable<T> by enumerating it asynchronously according to a specified key selector function.
ToDictionaryAsync<TSource,TKey>(IQueryable<TSource>, Func<TSource,TKey>, IEqualityComparer<TKey>)	Creates a Dictionary<TKey,TValue> from an IQueryable<T> by enumerating it asynchronously according to a specified key selector function and a comparer.
ToDictionaryAsync<TSource,TKey>(IQueryable<TSource>, Func<TSource,TKey>, IEqualityComparer<TKey>, CancellationToken)	Creates a Dictionary<TKey,TValue> from an IQueryable<T> by enumerating it asynchronously according to a specified key selector function and a comparer.
ToDictionaryAsync<TSource,TKey>(IQueryable<TSource>, Func<TSource,TKey>, CancellationToken)	Creates a Dictionary<TKey,TValue> from an IQueryable<T> by enumerating it asynchronously according to a specified key selector function.
ToDictionaryAsync<TSource,TKey,TElement>(IQueryable<TSource>, Func<TSource,TKey>, Func<TSource,TElement>)	Creates a Dictionary<TKey,TValue> from an IQueryable<T> by enumerating it asynchronously according to a specified key selector and an element selector function.
ToDictionaryAsync<TSource,TKey,TElement>(IQueryable<TSource>, Func<TSource,TKey>, Func<TSource,TElement>, IEqualityComparer<TKey>)	Creates a Dictionary<TKey,TValue> from an IQueryable<T> by enumerating it asynchronously according to a specified key selector function, a comparer, and an element selector function.
ToDictionaryAsync<TSource,TKey,TElement>(IQueryable<TSource>, Func<TSource,TKey>, Func<TSource,TElement>, IEqualityComparer<TKey>, CancellationToken)	Creates a Dictionary<TKey,TValue> from an IQueryable<T> by enumerating it asynchronously according to a specified key selector function, a comparer, and an element selector function.
ToDictionaryAsync<TSource,TKey,TElement>(IQueryable<TSource>, Func<TSource,TKey>, Func<TSource,TElement>, CancellationToken)	Creates a Dictionary<TKey,TValue> from an IQueryable<T> by enumerating it asynchronously according to a specified key selector and an element selector function.
ToListAsync<TSource>(IQueryable<TSource>)	Creates a List<T> from an IQueryable<T> by enumerating it asynchronously.
ToListAsync<TSource>(IQueryable<TSource>, CancellationToken)	Creates a List<T> from an IQueryable<T> by enumerating it asynchronously.

Applies to