DbSet<TEntity> DbSet<TEntity> DbSet<TEntity> Class

Definition

A DbSet represents the collection of all entities in the context, or that can be queried from the database, of a given type. DbSet objects are created from a DbContext using the DbContext.Set method.

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Naming", "CA1710:IdentifiersShouldHaveCorrectSuffix", Justification="Name is intentional")]
public class DbSet<TEntity> : System.Data.Entity.Infrastructure.DbQuery<TEntity>, System.Collections.Generic.IEnumerable<TEntity>, System.Data.Entity.IDbSet<TEntity>, System.Linq.IQueryable<TEntity> where TEntity : class
type DbSet<'Entity (requires 'Entity : null)> = class
    inherit DbQuery<'Entity (requires 'Entity : null)>
    interface IDbSet<'Entity (requires 'Entity : null)>
    interface IQueryable<'Entity (requires 'Entity : null)>
    interface seq<'Entity (requires 'Entity : null)>
    interface IQueryable
    interface IEnumerable
Public Class DbSet(Of TEntity)
Inherits DbQuery(Of TEntity)
Implements IDbSet(Of TEntity), IEnumerable(Of TEntity), IQueryable(Of TEntity)

Type Parameters

TEntity

The type that defines the set.

Inheritance
DbSet<TEntity>DbSet<TEntity>DbSet<TEntity>
Attributes
Implements

Remarks

Note that DbSet does not support MEST (Multiple Entity Sets per Type) meaning that there is always a

one-to-one correlation between a type and a set.

Constructors

DbSet<TEntity>() DbSet<TEntity>() DbSet<TEntity>()

Creates an instance of a DbSet<TEntity> when called from the constructor of a derived type that will be used as a test double for DbSets. Methods and properties that will be used by the test double must be implemented by the test double except AsNoTracking, AsStreaming, an Include where the default implementation is a no-op.

Properties

IListSource.ContainsListCollection IListSource.ContainsListCollection IListSource.ContainsListCollection

Returns false.

(Inherited from DbQuery<TResult>)
IQueryable.ElementType IQueryable.ElementType IQueryable.ElementType

The IQueryable element type.

(Inherited from DbQuery<TResult>)
IQueryable.Expression IQueryable.Expression IQueryable.Expression

The IQueryable LINQ Expression.

(Inherited from DbQuery<TResult>)
IQueryable.Provider IQueryable.Provider IQueryable.Provider

The IQueryable provider.

(Inherited from DbQuery<TResult>)
Local Local Local
Sql Sql Sql

Gets a String representation of the underlying query.

(Inherited from DbQuery<TResult>)

Methods

Add(TEntity) Add(TEntity) Add(TEntity)
AddRange(IEnumerable<TEntity>) AddRange(IEnumerable<TEntity>) AddRange(IEnumerable<TEntity>)

Adds the given collection of entities into context underlying the set with each entity being put into the Added state such that it will be inserted into the database when SaveChanges is called.

AsNoTracking() AsNoTracking() AsNoTracking()

Returns a new query where the entities returned will not be cached in the DbContext.

(Inherited from DbQuery<TResult>)
AsStreaming() AsStreaming() AsStreaming()

Returns a new query that will stream the results instead of buffering.

(Inherited from DbQuery<TResult>)
Attach(TEntity) Attach(TEntity) Attach(TEntity)
Create() Create() Create()
Create<TDerivedEntity>() Create<TDerivedEntity>() Create<TDerivedEntity>()
Equals(Object) Equals(Object) Equals(Object)
Find(Object[]) Find(Object[]) Find(Object[])

Finds an entity with the given primary key values. If an entity with the given primary key values exists in the context, then it is returned immediately without making a request to the store. Otherwise, a request is made to the store for an entity with the given primary key values and this entity, if found, is attached to the context and returned. If no entity is found in the context or the store, then null is returned.

FindAsync(CancellationToken, Object[]) FindAsync(CancellationToken, Object[]) FindAsync(CancellationToken, Object[])

Asynchronously finds an entity with the given primary key values. If an entity with the given primary key values exists in the context, then it is returned immediately without making a request to the store. Otherwise, a request is made to the store for an entity with the given primary key values and this entity, if found, is attached to the context and returned. If no entity is found in the context or the store, then null is returned.

FindAsync(Object[]) FindAsync(Object[]) FindAsync(Object[])

Asynchronously finds an entity with the given primary key values. If an entity with the given primary key values exists in the context, then it is returned immediately without making a request to the store. Otherwise, a request is made to the store for an entity with the given primary key values and this entity, if found, is attached to the context and returned. If no entity is found in the context or the store, then null is returned.

GetHashCode() GetHashCode() GetHashCode()
GetType() GetType() GetType()
Include(String) Include(String) Include(String)

Specifies the related objects to include in the query results.

(Inherited from DbQuery<TResult>)
Remove(TEntity) Remove(TEntity) Remove(TEntity)
RemoveRange(IEnumerable<TEntity>) RemoveRange(IEnumerable<TEntity>) RemoveRange(IEnumerable<TEntity>)

Removes the given collection of entities from the context underlying the set with each entity being put into the Deleted state such that it will be deleted from the database when SaveChanges is called.

SqlQuery(String, Object[]) SqlQuery(String, Object[]) SqlQuery(String, Object[])

Creates a raw SQL query that will return entities in this set. By default, the entities returned are tracked by the context; this can be changed by calling AsNoTracking on the DbSqlQuery<TEntity> returned. Note that the entities returned are always of the type for this set and never of a derived type. If the table or tables queried may contain data for other entity types, then the SQL query must be written appropriately to ensure that only entities of the correct type are returned.

As with any API that accepts SQL it is important to parameterize any user input to protect against a SQL injection attack. You can include parameter place holders in the SQL query string and then supply parameter values as additional arguments. Any parameter values you supply will automatically be converted to a DbParameter. context.Blogs.SqlQuery("SELECT * FROM dbo.Posts WHERE Author = @p0", userSuppliedAuthor); Alternatively, you can also construct a DbParameter and supply it to SqlQuery. This allows you to use named parameters in the SQL query string. context.Blogs.SqlQuery("SELECT * FROM dbo.Posts WHERE Author = @author", new SqlParameter("@author", userSuppliedAuthor));

ToString() ToString() ToString()

Returns a String representation of the underlying query.

(Inherited from DbQuery<TResult>)

Operators

Implicit(DbSet<TEntity> to DbSet) Implicit(DbSet<TEntity> to DbSet) Implicit(DbSet<TEntity> to DbSet)

Returns the equivalent non-generic DbSet object.

Explicit Interface Implementations

IDbAsyncEnumerable.GetAsyncEnumerator() IDbAsyncEnumerable.GetAsyncEnumerator() IDbAsyncEnumerable.GetAsyncEnumerator()

Returns an IDbAsyncEnumerator which when enumerated will execute the query against the database.

(Inherited from DbQuery<TResult>)
IDbAsyncEnumerable<TResult>.GetAsyncEnumerator() IDbAsyncEnumerable<TResult>.GetAsyncEnumerator() IDbAsyncEnumerable<TResult>.GetAsyncEnumerator()

Returns an IDbAsyncEnumerator<T> which when enumerated will execute the query against the database.

(Inherited from DbQuery<TResult>)
IEnumerable.GetEnumerator() IEnumerable.GetEnumerator() IEnumerable.GetEnumerator()

Returns an IEnumerator<T> which when enumerated will execute the query against the database.

(Inherited from DbQuery<TResult>)
IEnumerable<TResult>.GetEnumerator() IEnumerable<TResult>.GetEnumerator() IEnumerable<TResult>.GetEnumerator()

Returns an IEnumerator<T> which when enumerated will execute the query against the database.

(Inherited from DbQuery<TResult>)
IListSource.GetList() IListSource.GetList() 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().

(Inherited from DbQuery<TResult>)

Extension Methods

AddOrUpdate<TEntity>(IDbSet<TEntity>, TEntity[]) AddOrUpdate<TEntity>(IDbSet<TEntity>, TEntity[]) AddOrUpdate<TEntity>(IDbSet<TEntity>, TEntity[])

Adds or updates entities by key when SaveChanges is called. Equivalent to an "upsert" operation from database terminology. This method can useful when seeding data using Migrations.

AddOrUpdate<TEntity>(IDbSet<TEntity>, Expression<Func<TEntity,Object>>, TEntity[]) AddOrUpdate<TEntity>(IDbSet<TEntity>, Expression<Func<TEntity,Object>>, TEntity[]) AddOrUpdate<TEntity>(IDbSet<TEntity>, Expression<Func<TEntity,Object>>, TEntity[])

Adds or updates entities by a custom identification expression when SaveChanges is called. Equivalent to an "upsert" operation from database terminology. This method can useful when seeding data using Migrations.

AllAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) AllAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) 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) AllAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken) 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>) AnyAsync<TSource>(IQueryable<TSource>) AnyAsync<TSource>(IQueryable<TSource>)

Asynchronously determines whether a sequence contains any elements.

AnyAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) AnyAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) 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) AnyAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken) 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) AnyAsync<TSource>(IQueryable<TSource>, CancellationToken) AnyAsync<TSource>(IQueryable<TSource>, CancellationToken)

Asynchronously determines whether a sequence contains any elements.

AsNoTracking(IQueryable) AsNoTracking(IQueryable) AsNoTracking(IQueryable)

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.

AsNoTracking<T>(IQueryable<T>) AsNoTracking<T>(IQueryable<T>) 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(IQueryable) AsStreaming(IQueryable) AsStreaming(IQueryable)

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.

AsStreaming<T>(IQueryable<T>) AsStreaming<T>(IQueryable<T>) AsStreaming<T>(IQueryable<T>)

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(IQueryable<Decimal>) AverageAsync(IQueryable<Decimal>) AverageAsync(IQueryable<Decimal>)

Asynchronously computes the average of a sequence of Decimal values.

AverageAsync(IQueryable<Decimal>, CancellationToken) AverageAsync(IQueryable<Decimal>, CancellationToken) AverageAsync(IQueryable<Decimal>, CancellationToken)

Asynchronously computes the average of a sequence of Decimal values.

AverageAsync(IQueryable<Double>) AverageAsync(IQueryable<Double>) AverageAsync(IQueryable<Double>)

Asynchronously computes the average of a sequence of Double values.

AverageAsync(IQueryable<Double>, CancellationToken) AverageAsync(IQueryable<Double>, CancellationToken) AverageAsync(IQueryable<Double>, CancellationToken)

Asynchronously computes the average of a sequence of Double values.

AverageAsync(IQueryable<Int32>) AverageAsync(IQueryable<Int32>) AverageAsync(IQueryable<Int32>)

Asynchronously computes the average of a sequence of Int32 values.

AverageAsync(IQueryable<Int32>, CancellationToken) AverageAsync(IQueryable<Int32>, CancellationToken) AverageAsync(IQueryable<Int32>, CancellationToken)

Asynchronously computes the average of a sequence of Int32 values.

AverageAsync(IQueryable<Int64>) AverageAsync(IQueryable<Int64>) AverageAsync(IQueryable<Int64>)

Asynchronously computes the average of a sequence of Int64 values.

AverageAsync(IQueryable<Int64>, CancellationToken) AverageAsync(IQueryable<Int64>, CancellationToken) AverageAsync(IQueryable<Int64>, CancellationToken)

Asynchronously computes the average of a sequence of Int64 values.

AverageAsync(IQueryable<Nullable<Decimal>>) AverageAsync(IQueryable<Nullable<Decimal>>) AverageAsync(IQueryable<Nullable<Decimal>>)

Asynchronously computes the average of a sequence of nullable Decimal values.

AverageAsync(IQueryable<Nullable<Decimal>>, CancellationToken) AverageAsync(IQueryable<Nullable<Decimal>>, CancellationToken) AverageAsync(IQueryable<Nullable<Decimal>>, CancellationToken)

Asynchronously computes the average of a sequence of nullable Decimal values.

AverageAsync(IQueryable<Nullable<Double>>) AverageAsync(IQueryable<Nullable<Double>>) AverageAsync(IQueryable<Nullable<Double>>)

Asynchronously computes the average of a sequence of nullable Double values.

AverageAsync(IQueryable<Nullable<Double>>, CancellationToken) AverageAsync(IQueryable<Nullable<Double>>, CancellationToken) AverageAsync(IQueryable<Nullable<Double>>, CancellationToken)

Asynchronously computes the average of a sequence of nullable Double values.

AverageAsync(IQueryable<Nullable<Int32>>) AverageAsync(IQueryable<Nullable<Int32>>) AverageAsync(IQueryable<Nullable<Int32>>)

Asynchronously computes the average of a sequence of nullable Int32 values.

AverageAsync(IQueryable<Nullable<Int32>>, CancellationToken) AverageAsync(IQueryable<Nullable<Int32>>, CancellationToken) AverageAsync(IQueryable<Nullable<Int32>>, CancellationToken)

Asynchronously computes the average of a sequence of nullable Int32 values.

AverageAsync(IQueryable<Nullable<Int64>>) AverageAsync(IQueryable<Nullable<Int64>>) AverageAsync(IQueryable<Nullable<Int64>>)

Asynchronously computes the average of a sequence of nullable Int64 values.

AverageAsync(IQueryable<Nullable<Int64>>, CancellationToken) AverageAsync(IQueryable<Nullable<Int64>>, CancellationToken) AverageAsync(IQueryable<Nullable<Int64>>, CancellationToken)

Asynchronously computes the average of a sequence of nullable Int64 values.

AverageAsync(IQueryable<Nullable<Single>>) AverageAsync(IQueryable<Nullable<Single>>) AverageAsync(IQueryable<Nullable<Single>>)

Asynchronously computes the average of a sequence of nullable Single values.

AverageAsync(IQueryable<Nullable<Single>>, CancellationToken) AverageAsync(IQueryable<Nullable<Single>>, CancellationToken) AverageAsync(IQueryable<Nullable<Single>>, CancellationToken)

Asynchronously computes the average of a sequence of nullable Single values.

AverageAsync(IQueryable<Single>) AverageAsync(IQueryable<Single>) AverageAsync(IQueryable<Single>)

Asynchronously computes the average of a sequence of Single values.

AverageAsync(IQueryable<Single>, CancellationToken) AverageAsync(IQueryable<Single>, CancellationToken) AverageAsync(IQueryable<Single>, CancellationToken)

Asynchronously computes the average of a sequence of Single values.

AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) 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) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>, CancellationToken) 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>>) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) 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) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>, CancellationToken) 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>>) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>) 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) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>, CancellationToken) 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>>) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>) 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) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>, CancellationToken) 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>>>) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>) 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) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>, CancellationToken) 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>>>) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>) 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) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>, CancellationToken) 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>>>) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>) 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) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>, CancellationToken) 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>>>) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>) 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) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>, CancellationToken) 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>>>) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>) 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) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>, CancellationToken) 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>>) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>) 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) AverageAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>, CancellationToken) 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) ContainsAsync<TSource>(IQueryable<TSource>, TSource) 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) ContainsAsync<TSource>(IQueryable<TSource>, TSource, CancellationToken) 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>) CountAsync<TSource>(IQueryable<TSource>) CountAsync<TSource>(IQueryable<TSource>)

Asynchronously returns the number of elements in a sequence.

CountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) CountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) 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) CountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken) 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) CountAsync<TSource>(IQueryable<TSource>, CancellationToken) CountAsync<TSource>(IQueryable<TSource>, CancellationToken)

Asynchronously returns the number of elements in a sequence.

FirstAsync<TSource>(IQueryable<TSource>) FirstAsync<TSource>(IQueryable<TSource>) FirstAsync<TSource>(IQueryable<TSource>)

Asynchronously returns the first element of a sequence.

FirstAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) FirstAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) 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) FirstAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken) 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) FirstAsync<TSource>(IQueryable<TSource>, CancellationToken) FirstAsync<TSource>(IQueryable<TSource>, CancellationToken)

Asynchronously returns the first element of a sequence.

FirstOrDefaultAsync<TSource>(IQueryable<TSource>) FirstOrDefaultAsync<TSource>(IQueryable<TSource>) 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>>) FirstOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) 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) FirstOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken) 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) FirstOrDefaultAsync<TSource>(IQueryable<TSource>, CancellationToken) FirstOrDefaultAsync<TSource>(IQueryable<TSource>, CancellationToken)

Asynchronously returns the first element of a sequence, or a default value if the sequence contains no elements.

ForEachAsync(IQueryable, Action<Object>) ForEachAsync(IQueryable, Action<Object>) ForEachAsync(IQueryable, Action<Object>)

Asynchronously enumerates the query results and performs the specified action on each element.

ForEachAsync(IQueryable, Action<Object>, CancellationToken) ForEachAsync(IQueryable, Action<Object>, CancellationToken) ForEachAsync(IQueryable, Action<Object>, CancellationToken)

Asynchronously enumerates the query results and performs the specified action on each element.

ForEachAsync<T>(IQueryable<T>, Action<T>) ForEachAsync<T>(IQueryable<T>, Action<T>) 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) ForEachAsync<T>(IQueryable<T>, Action<T>, CancellationToken) ForEachAsync<T>(IQueryable<T>, Action<T>, CancellationToken)

Asynchronously enumerates the query results and performs the specified action on each element.

Include(IQueryable, String) Include(IQueryable, String) Include(IQueryable, String)

Specifies the related objects to include in the query results.

Include<T>(IQueryable<T>, String) Include<T>(IQueryable<T>, String) Include<T>(IQueryable<T>, String)

Specifies the related objects to include in the query results.

Include<T,TProperty>(IQueryable<T>, Expression<Func<T,TProperty>>) Include<T,TProperty>(IQueryable<T>, Expression<Func<T,TProperty>>) Include<T,TProperty>(IQueryable<T>, Expression<Func<T,TProperty>>)

Specifies the related objects to include in the query results.

Load(IQueryable) Load(IQueryable) Load(IQueryable)

Enumerates the query such that for server queries such as those of DbSet<TEntity>, ObjectSet<TEntity> , ObjectQuery<T>, and others the results of the query will be loaded into the associated DbContext , ObjectContext or other cache on the client. This is equivalent to calling ToList and then throwing away the list without the overhead of actually creating the list.

LoadAsync(IQueryable) LoadAsync(IQueryable) LoadAsync(IQueryable)

Asynchronously enumerates the query such that for server queries such as those of DbSet<TEntity>, ObjectSet<TEntity> , ObjectQuery<T>, and others the results of the query will be loaded into the associated DbContext , ObjectContext or other cache on the client. This is equivalent to calling ToList and then throwing away the list without the overhead of actually creating the list.

LoadAsync(IQueryable, CancellationToken) LoadAsync(IQueryable, CancellationToken) LoadAsync(IQueryable, CancellationToken)

Asynchronously enumerates the query such that for server queries such as those of DbSet<TEntity>, ObjectSet<TEntity> , ObjectQuery<T>, and others the results of the query will be loaded into the associated DbContext , ObjectContext or other cache on the client. This is equivalent to calling ToList and then throwing away the list without the overhead of actually creating the list.

LongCountAsync<TSource>(IQueryable<TSource>) LongCountAsync<TSource>(IQueryable<TSource>) 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>>) LongCountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) 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) LongCountAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken) 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) LongCountAsync<TSource>(IQueryable<TSource>, CancellationToken) LongCountAsync<TSource>(IQueryable<TSource>, CancellationToken)

Asynchronously returns an Int64 that represents the total number of elements in a sequence.

MaxAsync<TSource>(IQueryable<TSource>) MaxAsync<TSource>(IQueryable<TSource>) MaxAsync<TSource>(IQueryable<TSource>)

Asynchronously returns the maximum value of a sequence.

MaxAsync<TSource>(IQueryable<TSource>, CancellationToken) MaxAsync<TSource>(IQueryable<TSource>, CancellationToken) MaxAsync<TSource>(IQueryable<TSource>, CancellationToken)

Asynchronously returns the maximum value of a sequence.

MaxAsync<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) MaxAsync<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) 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) MaxAsync<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>, CancellationToken) 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>) MinAsync<TSource>(IQueryable<TSource>) MinAsync<TSource>(IQueryable<TSource>)

Asynchronously returns the minimum value of a sequence.

MinAsync<TSource>(IQueryable<TSource>, CancellationToken) MinAsync<TSource>(IQueryable<TSource>, CancellationToken) MinAsync<TSource>(IQueryable<TSource>, CancellationToken)

Asynchronously returns the minimum value of a sequence.

MinAsync<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) MinAsync<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) 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) MinAsync<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>, CancellationToken) 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>) SingleAsync<TSource>(IQueryable<TSource>) 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>>) SingleAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) 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) SingleAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken) 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) SingleAsync<TSource>(IQueryable<TSource>, CancellationToken) 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>) SingleOrDefaultAsync<TSource>(IQueryable<TSource>) 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>>) SingleOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) 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) SingleOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>, CancellationToken) 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) SingleOrDefaultAsync<TSource>(IQueryable<TSource>, CancellationToken) 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>>) Skip<TSource>(IQueryable<TSource>, Expression<Func<Int32>>) Skip<TSource>(IQueryable<TSource>, Expression<Func<Int32>>)

Bypasses a specified number of elements in a sequence and then returns the remaining elements.

SumAsync(IQueryable<Decimal>) SumAsync(IQueryable<Decimal>) SumAsync(IQueryable<Decimal>)

Asynchronously computes the sum of a sequence of Decimal values.

SumAsync(IQueryable<Decimal>, CancellationToken) SumAsync(IQueryable<Decimal>, CancellationToken) SumAsync(IQueryable<Decimal>, CancellationToken)

Asynchronously computes the sum of a sequence of Decimal values.

SumAsync(IQueryable<Double>) SumAsync(IQueryable<Double>) SumAsync(IQueryable<Double>)

Asynchronously computes the sum of a sequence of Double values.

SumAsync(IQueryable<Double>, CancellationToken) SumAsync(IQueryable<Double>, CancellationToken) SumAsync(IQueryable<Double>, CancellationToken)

Asynchronously computes the sum of a sequence of Double values.

SumAsync(IQueryable<Int32>) SumAsync(IQueryable<Int32>) SumAsync(IQueryable<Int32>)

Asynchronously computes the sum of a sequence of Int32 values.

SumAsync(IQueryable<Int32>, CancellationToken) SumAsync(IQueryable<Int32>, CancellationToken) SumAsync(IQueryable<Int32>, CancellationToken)

Asynchronously computes the sum of a sequence of Int32 values.

SumAsync(IQueryable<Int64>) SumAsync(IQueryable<Int64>) SumAsync(IQueryable<Int64>)

Asynchronously computes the sum of a sequence of Int64 values.

SumAsync(IQueryable<Int64>, CancellationToken) SumAsync(IQueryable<Int64>, CancellationToken) SumAsync(IQueryable<Int64>, CancellationToken)

Asynchronously computes the sum of a sequence of Int64 values.

SumAsync(IQueryable<Nullable<Decimal>>) SumAsync(IQueryable<Nullable<Decimal>>) SumAsync(IQueryable<Nullable<Decimal>>)

Asynchronously computes the sum of a sequence of nullable Decimal values.

SumAsync(IQueryable<Nullable<Decimal>>, CancellationToken) SumAsync(IQueryable<Nullable<Decimal>>, CancellationToken) SumAsync(IQueryable<Nullable<Decimal>>, CancellationToken)

Asynchronously computes the sum of a sequence of nullable Decimal values.

SumAsync(IQueryable<Nullable<Double>>) SumAsync(IQueryable<Nullable<Double>>) SumAsync(IQueryable<Nullable<Double>>)

Asynchronously computes the sum of a sequence of nullable Double values.

SumAsync(IQueryable<Nullable<Double>>, CancellationToken) SumAsync(IQueryable<Nullable<Double>>, CancellationToken) SumAsync(IQueryable<Nullable<Double>>, CancellationToken)

Asynchronously computes the sum of a sequence of nullable Double values.

SumAsync(IQueryable<Nullable<Int32>>) SumAsync(IQueryable<Nullable<Int32>>) SumAsync(IQueryable<Nullable<Int32>>)

Asynchronously computes the sum of a sequence of nullable Int32 values.

SumAsync(IQueryable<Nullable<Int32>>, CancellationToken) SumAsync(IQueryable<Nullable<Int32>>, CancellationToken) SumAsync(IQueryable<Nullable<Int32>>, CancellationToken)

Asynchronously computes the sum of a sequence of nullable Int32 values.

SumAsync(IQueryable<Nullable<Int64>>) SumAsync(IQueryable<Nullable<Int64>>) SumAsync(IQueryable<Nullable<Int64>>)

Asynchronously computes the sum of a sequence of nullable Int64 values.

SumAsync(IQueryable<Nullable<Int64>>, CancellationToken) SumAsync(IQueryable<Nullable<Int64>>, CancellationToken) SumAsync(IQueryable<Nullable<Int64>>, CancellationToken)

Asynchronously computes the sum of a sequence of nullable Int64 values.

SumAsync(IQueryable<Nullable<Single>>) SumAsync(IQueryable<Nullable<Single>>) SumAsync(IQueryable<Nullable<Single>>)

Asynchronously computes the sum of a sequence of nullable Single values.

SumAsync(IQueryable<Nullable<Single>>, CancellationToken) SumAsync(IQueryable<Nullable<Single>>, CancellationToken) SumAsync(IQueryable<Nullable<Single>>, CancellationToken)

Asynchronously computes the sum of a sequence of nullable Single values.

SumAsync(IQueryable<Single>) SumAsync(IQueryable<Single>) SumAsync(IQueryable<Single>)

Asynchronously computes the sum of a sequence of Single values.

SumAsync(IQueryable<Single>, CancellationToken) SumAsync(IQueryable<Single>, CancellationToken) SumAsync(IQueryable<Single>, CancellationToken)

Asynchronously computes the sum of a sequence of Single values.

SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) 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) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>, CancellationToken) 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>>) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) 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) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>, CancellationToken) 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>>) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>) 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) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>, CancellationToken) 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>>) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>) 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) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>, CancellationToken) 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>>>) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>) 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) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>, CancellationToken) 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>>>) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>) 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) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>, CancellationToken) 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>>>) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>) 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) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>, CancellationToken) 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>>>) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>) 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) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>, CancellationToken) 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>>>) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>) 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) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>, CancellationToken) 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>>) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>) 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) SumAsync<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>, CancellationToken) 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>>) Take<TSource>(IQueryable<TSource>, Expression<Func<Int32>>) Take<TSource>(IQueryable<TSource>, Expression<Func<Int32>>)

Returns a specified number of contiguous elements from the start of a sequence.

ToArrayAsync<TSource>(IQueryable<TSource>) ToArrayAsync<TSource>(IQueryable<TSource>) ToArrayAsync<TSource>(IQueryable<TSource>)

Creates an array from an IQueryable<T> by enumerating it asynchronously.

ToArrayAsync<TSource>(IQueryable<TSource>, CancellationToken) ToArrayAsync<TSource>(IQueryable<TSource>, CancellationToken) ToArrayAsync<TSource>(IQueryable<TSource>, CancellationToken)

Creates an array from an IQueryable<T> by enumerating it asynchronously.

ToDictionaryAsync<TSource,TKey>(IQueryable<TSource>, Func<TSource,TKey>) ToDictionaryAsync<TSource,TKey>(IQueryable<TSource>, Func<TSource,TKey>) 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>) ToDictionaryAsync<TSource,TKey>(IQueryable<TSource>, Func<TSource,TKey>, IEqualityComparer<TKey>) 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) ToDictionaryAsync<TSource,TKey>(IQueryable<TSource>, Func<TSource,TKey>, IEqualityComparer<TKey>, CancellationToken) 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) ToDictionaryAsync<TSource,TKey>(IQueryable<TSource>, Func<TSource,TKey>, CancellationToken) 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>) ToDictionaryAsync<TSource,TKey,TElement>(IQueryable<TSource>, Func<TSource,TKey>, Func<TSource,TElement>) 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>) ToDictionaryAsync<TSource,TKey,TElement>(IQueryable<TSource>, Func<TSource,TKey>, Func<TSource,TElement>, IEqualityComparer<TKey>) 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) ToDictionaryAsync<TSource,TKey,TElement>(IQueryable<TSource>, Func<TSource,TKey>, Func<TSource,TElement>, IEqualityComparer<TKey>, CancellationToken) 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) ToDictionaryAsync<TSource,TKey,TElement>(IQueryable<TSource>, Func<TSource,TKey>, Func<TSource,TElement>, CancellationToken) 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(IQueryable) ToListAsync(IQueryable) ToListAsync(IQueryable)

Creates a List<T> from an IQueryable by enumerating it asynchronously.

ToListAsync(IQueryable, CancellationToken) ToListAsync(IQueryable, CancellationToken) ToListAsync(IQueryable, CancellationToken)

Creates a List<T> from an IQueryable by enumerating it asynchronously.

ToListAsync<TSource>(IQueryable<TSource>) ToListAsync<TSource>(IQueryable<TSource>) ToListAsync<TSource>(IQueryable<TSource>)

Creates a List<T> from an IQueryable<T> by enumerating it asynchronously.

ToListAsync<TSource>(IQueryable<TSource>, CancellationToken) ToListAsync<TSource>(IQueryable<TSource>, CancellationToken) ToListAsync<TSource>(IQueryable<TSource>, CancellationToken)

Creates a List<T> from an IQueryable<T> by enumerating it asynchronously.

Applies to