Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Table<TEntity> Class

Represents a table for a particular type in the underlying database.

System.Object
  System.Data.Linq.Table<TEntity>

Namespace:  System.Data.Linq
Assembly:  System.Data.Linq (in System.Data.Linq.dll)
public sealed class Table<TEntity> : IQueryProvider, 
	ITable, IListSource, ITable<TEntity>, IQueryable<TEntity>, 
	IEnumerable<TEntity>, IQueryable, IEnumerable 
where TEntity : class

Type Parameters

TEntity

The type of the data in the table.

The Table<TEntity> type exposes the following members.

  NameDescription
Public propertyContextGets the DataContext that has been used to retrieve this Table<TEntity>.
Public propertyIsReadOnlyGets a value that indicates whether the type of the entities contained in this Table<TEntity> instance has a primary key.
Top
  NameDescription
Public methodAttach(TEntity)Attaches a disconnected or "detached" entity to a new DataContext when original values are required for optimistic concurrency checks.
Public methodAttach(TEntity, Boolean)Attaches an entity to the DataContext in either a modified or unmodified state.
Public methodAttach(TEntity, TEntity)Attaches an entity to the DataContext in either a modified or unmodified state by specifying both the entity and its original state.
Public methodAttachAll<TSubEntity>(IEnumerable<TSubEntity>)Attaches all entities of a collection to the DataContext in either a modified or unmodified state.
Public methodAttachAll<TSubEntity>(IEnumerable<TSubEntity>, Boolean)Attaches all entities of a collection to the DataContext in either a modified or unmodified state.
Public methodDeleteAllOnSubmit<TSubEntity>Puts all entities from the collection into a pending delete state.
Public methodDeleteOnSubmitPuts an entity from this table into a pending delete state.
Public methodEquals(Object)Determines whether the specified object is equal to the current object. (Inherited from Object.)
Public methodGetEnumeratorGets an enumerator that iterates through the collection.
Public methodGetHashCodeServes as the default hash function. (Inherited from Object.)
Public methodGetModifiedMembersReturns an array of modified members that contain their current and original values.
Public methodGetNewBindingListCreates a new list for binding to a data source.
Public methodGetOriginalEntityStateReturns a Table<TEntity> instance that contains the original state of the entity.
Public methodGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodInsertAllOnSubmit<TSubEntity>Adds all entities of a collection to the DataContext in a pending insert state.
Public methodInsertOnSubmitAdds an entity in a pending insert state to this Table<TEntity>.
Public methodToStringReturns a string that represents the table. (Overrides Object.ToString().)
Top
  NameDescription
Public Extension MethodAggregate<TEntity>(Expression<Func<TEntity, TEntity, TEntity>>)Overloaded. Applies an accumulator function over a sequence. (Defined by Queryable.)
Public Extension MethodAggregate<TEntity>(Func<TEntity, TEntity, TEntity>)Overloaded. Applies an accumulator function over a sequence. (Defined by Enumerable.)
Public Extension MethodAggregate<TEntity, TAccumulate>(TAccumulate, Expression<Func<TAccumulate, TEntity, TAccumulate>>)Overloaded. Applies an accumulator function over a sequence. The specified seed value is used as the initial accumulator value. (Defined by Queryable.)
Public Extension MethodAggregate<TEntity, TAccumulate>(TAccumulate, Func<TAccumulate, TEntity, TAccumulate>)Overloaded. Applies an accumulator function over a sequence. The specified seed value is used as the initial accumulator value. (Defined by Enumerable.)
Public Extension MethodAggregate<TEntity, TAccumulate, TResult>(TAccumulate, Expression<Func<TAccumulate, TEntity, TAccumulate>>, Expression<Func<TAccumulate, TResult>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodAggregate<TEntity, TAccumulate, TResult>(TAccumulate, Func<TAccumulate, TEntity, TAccumulate>, Func<TAccumulate, TResult>)Overloaded. 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. (Defined by Enumerable.)
Public Extension MethodAll<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. Determines whether all the elements of a sequence satisfy a condition. (Defined by Queryable.)
Public Extension MethodAll<TEntity>(Func<TEntity, Boolean>)Overloaded. Determines whether all elements of a sequence satisfy a condition. (Defined by Enumerable.)
Public Extension MethodAny<TEntity>()Overloaded. Determines whether a sequence contains any elements. (Defined by Queryable.)
Public Extension MethodAny<TEntity>()Overloaded. Determines whether a sequence contains any elements. (Defined by Enumerable.)
Public Extension MethodAny<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. Determines whether any element of a sequence satisfies a condition. (Defined by Queryable.)
Public Extension MethodAny<TEntity>(Func<TEntity, Boolean>)Overloaded. Determines whether any element of a sequence satisfies a condition. (Defined by Enumerable.)
Public Extension MethodAsEnumerable<TEntity>Returns the input typed as IEnumerable<T>. (Defined by Enumerable.)
Public Extension MethodAsParallel()Overloaded. Enables parallelization of a query. (Defined by ParallelEnumerable.)
Public Extension MethodAsParallel<TEntity>()Overloaded. Enables parallelization of a query. (Defined by ParallelEnumerable.)
Public Extension MethodAsQueryable()Overloaded. Converts an IEnumerable to an IQueryable. (Defined by Queryable.)
Public Extension MethodAsQueryable<TEntity>()Overloaded. Converts a generic IEnumerable<T> to a generic IQueryable<T>. (Defined by Queryable.)
Public Extension MethodAverage<TEntity>(Expression<Func<TEntity, Decimal>>)Overloaded. Computes the average of a sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence. (Defined by Queryable.)
Public Extension MethodAverage<TEntity>(Expression<Func<TEntity, Nullable<Decimal>>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodAverage<TEntity>(Func<TEntity, Decimal>)Overloaded. Computes the average of a sequence of Decimal values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodAverage<TEntity>(Func<TEntity, Nullable<Decimal>>)Overloaded. Computes the average of a sequence of nullable Decimal values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodAverage<TEntity>(Expression<Func<TEntity, Double>>)Overloaded. Computes the average of a sequence of Double values that is obtained by invoking a projection function on each element of the input sequence. (Defined by Queryable.)
Public Extension MethodAverage<TEntity>(Expression<Func<TEntity, Nullable<Double>>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodAverage<TEntity>(Func<TEntity, Double>)Overloaded. Computes the average of a sequence of Double values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodAverage<TEntity>(Func<TEntity, Nullable<Double>>)Overloaded. Computes the average of a sequence of nullable Double values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodAverage<TEntity>(Expression<Func<TEntity, Int32>>)Overloaded. Computes the average of a sequence of Int32 values that is obtained by invoking a projection function on each element of the input sequence. (Defined by Queryable.)
Public Extension MethodAverage<TEntity>(Expression<Func<TEntity, Nullable<Int32>>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodAverage<TEntity>(Expression<Func<TEntity, Single>>)Overloaded. Computes the average of a sequence of Single values that is obtained by invoking a projection function on each element of the input sequence. (Defined by Queryable.)
Public Extension MethodAverage<TEntity>(Expression<Func<TEntity, Nullable<Single>>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodAverage<TEntity>(Expression<Func<TEntity, Int64>>)Overloaded. Computes the average of a sequence of Int64 values that is obtained by invoking a projection function on each element of the input sequence. (Defined by Queryable.)
Public Extension MethodAverage<TEntity>(Expression<Func<TEntity, Nullable<Int64>>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodAverage<TEntity>(Func<TEntity, Int32>)Overloaded. Computes the average of a sequence of Int32 values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodAverage<TEntity>(Func<TEntity, Nullable<Int32>>)Overloaded. Computes the average of a sequence of nullable Int32 values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodAverage<TEntity>(Func<TEntity, Int64>)Overloaded. Computes the average of a sequence of Int64 values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodAverage<TEntity>(Func<TEntity, Nullable<Int64>>)Overloaded. Computes the average of a sequence of nullable Int64 values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodAverage<TEntity>(Func<TEntity, Single>)Overloaded. Computes the average of a sequence of Single values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodAverage<TEntity>(Func<TEntity, Nullable<Single>>)Overloaded. Computes the average of a sequence of nullable Single values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodCast<TResult>()Overloaded. Converts the elements of an IQueryable to the specified type. (Defined by Queryable.)
Public Extension MethodCast<TResult>()Overloaded. Casts the elements of an IEnumerable to the specified type. (Defined by Enumerable.)
Public Extension MethodConcat<TEntity>(IEnumerable<TEntity>)Overloaded. Concatenates two sequences. (Defined by Queryable.)
Public Extension MethodConcat<TEntity>(IEnumerable<TEntity>)Overloaded. Concatenates two sequences. (Defined by Enumerable.)
Public Extension MethodContains<TEntity>(TEntity)Overloaded. Determines whether a sequence contains a specified element by using the default equality comparer. (Defined by Queryable.)
Public Extension MethodContains<TEntity>(TEntity)Overloaded. Determines whether a sequence contains a specified element by using the default equality comparer. (Defined by Enumerable.)
Public Extension MethodContains<TEntity>(TEntity, IEqualityComparer<TEntity>)Overloaded. Determines whether a sequence contains a specified element by using a specified IEqualityComparer<T>. (Defined by Queryable.)
Public Extension MethodContains<TEntity>(TEntity, IEqualityComparer<TEntity>)Overloaded. Determines whether a sequence contains a specified element by using a specified IEqualityComparer<T>. (Defined by Enumerable.)
Public Extension MethodCount<TEntity>()Overloaded. Returns the number of elements in a sequence. (Defined by Queryable.)
Public Extension MethodCount<TEntity>()Overloaded. Returns the number of elements in a sequence. (Defined by Enumerable.)
Public Extension MethodCount<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. Returns the number of elements in the specified sequence that satisfies a condition. (Defined by Queryable.)
Public Extension MethodCount<TEntity>(Func<TEntity, Boolean>)Overloaded. Returns a number that represents how many elements in the specified sequence satisfy a condition. (Defined by Enumerable.)
Public Extension MethodDefaultIfEmpty<TEntity>()Overloaded. Returns the elements of the specified sequence or the type parameter's default value in a singleton collection if the sequence is empty. (Defined by Queryable.)
Public Extension MethodDefaultIfEmpty<TEntity>()Overloaded. Returns the elements of the specified sequence or the type parameter's default value in a singleton collection if the sequence is empty. (Defined by Enumerable.)
Public Extension MethodDefaultIfEmpty<TEntity>(TEntity)Overloaded. Returns the elements of the specified sequence or the specified value in a singleton collection if the sequence is empty. (Defined by Queryable.)
Public Extension MethodDefaultIfEmpty<TEntity>(TEntity)Overloaded. Returns the elements of the specified sequence or the specified value in a singleton collection if the sequence is empty. (Defined by Enumerable.)
Public Extension MethodDistinct<TEntity>()Overloaded. Returns distinct elements from a sequence by using the default equality comparer to compare values. (Defined by Queryable.)
Public Extension MethodDistinct<TEntity>()Overloaded. Returns distinct elements from a sequence by using the default equality comparer to compare values. (Defined by Enumerable.)
Public Extension MethodDistinct<TEntity>(IEqualityComparer<TEntity>)Overloaded. Returns distinct elements from a sequence by using a specified IEqualityComparer<T> to compare values. (Defined by Queryable.)
Public Extension MethodDistinct<TEntity>(IEqualityComparer<TEntity>)Overloaded. Returns distinct elements from a sequence by using a specified IEqualityComparer<T> to compare values. (Defined by Enumerable.)
Public Extension MethodElementAt<TEntity>(Int32)Overloaded. Returns the element at a specified index in a sequence. (Defined by Queryable.)
Public Extension MethodElementAt<TEntity>(Int32)Overloaded. Returns the element at a specified index in a sequence. (Defined by Enumerable.)
Public Extension MethodElementAtOrDefault<TEntity>(Int32)Overloaded. Returns the element at a specified index in a sequence or a default value if the index is out of range. (Defined by Queryable.)
Public Extension MethodElementAtOrDefault<TEntity>(Int32)Overloaded. Returns the element at a specified index in a sequence or a default value if the index is out of range. (Defined by Enumerable.)
Public Extension MethodExcept<TEntity>(IEnumerable<TEntity>)Overloaded. Produces the set difference of two sequences by using the default equality comparer to compare values. (Defined by Queryable.)
Public Extension MethodExcept<TEntity>(IEnumerable<TEntity>)Overloaded. Produces the set difference of two sequences by using the default equality comparer to compare values. (Defined by Enumerable.)
Public Extension MethodExcept<TEntity>(IEnumerable<TEntity>, IEqualityComparer<TEntity>)Overloaded. Produces the set difference of two sequences by using the specified IEqualityComparer<T> to compare values. (Defined by Queryable.)
Public Extension MethodExcept<TEntity>(IEnumerable<TEntity>, IEqualityComparer<TEntity>)Overloaded. Produces the set difference of two sequences by using the specified IEqualityComparer<T> to compare values. (Defined by Enumerable.)
Public Extension MethodFirst<TEntity>()Overloaded. Returns the first element of a sequence. (Defined by Queryable.)
Public Extension MethodFirst<TEntity>()Overloaded. Returns the first element of a sequence. (Defined by Enumerable.)
Public Extension MethodFirst<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. Returns the first element of a sequence that satisfies a specified condition. (Defined by Queryable.)
Public Extension MethodFirst<TEntity>(Func<TEntity, Boolean>)Overloaded. Returns the first element in a sequence that satisfies a specified condition. (Defined by Enumerable.)
Public Extension MethodFirstOrDefault<TEntity>()Overloaded. Returns the first element of a sequence, or a default value if the sequence contains no elements. (Defined by Queryable.)
Public Extension MethodFirstOrDefault<TEntity>()Overloaded. Returns the first element of a sequence, or a default value if the sequence contains no elements. (Defined by Enumerable.)
Public Extension MethodFirstOrDefault<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. Returns the first element of a sequence that satisfies a specified condition or a default value if no such element is found. (Defined by Queryable.)
Public Extension MethodFirstOrDefault<TEntity>(Func<TEntity, Boolean>)Overloaded. Returns the first element of the sequence that satisfies a condition or a default value if no such element is found. (Defined by Enumerable.)
Public Extension MethodGroupBy<TEntity, TKey>(Expression<Func<TEntity, TKey>>)Overloaded. Groups the elements of a sequence according to a specified key selector function. (Defined by Queryable.)
Public Extension MethodGroupBy<TEntity, TKey>(Func<TEntity, TKey>)Overloaded. Groups the elements of a sequence according to a specified key selector function. (Defined by Enumerable.)
Public Extension MethodGroupBy<TEntity, TKey>(Expression<Func<TEntity, TKey>>, IEqualityComparer<TKey>)Overloaded. Groups the elements of a sequence according to a specified key selector function and compares the keys by using a specified comparer. (Defined by Queryable.)
Public Extension MethodGroupBy<TEntity, TKey>(Func<TEntity, TKey>, IEqualityComparer<TKey>)Overloaded. Groups the elements of a sequence according to a specified key selector function and compares the keys by using a specified comparer. (Defined by Enumerable.)
Public Extension MethodGroupBy<TEntity, TKey, TElement>(Expression<Func<TEntity, TKey>>, Expression<Func<TEntity, TElement>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodGroupBy<TEntity, TKey, TResult>(Expression<Func<TEntity, TKey>>, Expression<Func<TKey, IEnumerable<TEntity>, TResult>>)Overloaded. Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. (Defined by Queryable.)
Public Extension MethodGroupBy<TEntity, TKey, TElement>(Func<TEntity, TKey>, Func<TEntity, TElement>)Overloaded. 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. (Defined by Enumerable.)
Public Extension MethodGroupBy<TEntity, TKey, TResult>(Func<TEntity, TKey>, Func<TKey, IEnumerable<TEntity>, TResult>)Overloaded. Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. (Defined by Enumerable.)
Public Extension MethodGroupBy<TEntity, TKey, TElement>(Expression<Func<TEntity, TKey>>, Expression<Func<TEntity, TElement>>, IEqualityComparer<TKey>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodGroupBy<TEntity, TKey, TResult>(Expression<Func<TEntity, TKey>>, Expression<Func<TKey, IEnumerable<TEntity>, TResult>>, IEqualityComparer<TKey>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodGroupBy<TEntity, TKey, TElement>(Func<TEntity, TKey>, Func<TEntity, TElement>, IEqualityComparer<TKey>)Overloaded. Groups the elements of a sequence according to a key selector function. The keys are compared by using a comparer and each group's elements are projected by using a specified function. (Defined by Enumerable.)
Public Extension MethodGroupBy<TEntity, TKey, TResult>(Func<TEntity, TKey>, Func<TKey, IEnumerable<TEntity>, TResult>, IEqualityComparer<TKey>)Overloaded. 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 keys are compared by using a specified comparer. (Defined by Enumerable.)
Public Extension MethodGroupBy<TEntity, TKey, TElement, TResult>(Expression<Func<TEntity, TKey>>, Expression<Func<TEntity, TElement>>, Expression<Func<TKey, IEnumerable<TElement>, TResult>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodGroupBy<TEntity, TKey, TElement, TResult>(Func<TEntity, TKey>, Func<TEntity, TElement>, Func<TKey, IEnumerable<TElement>, TResult>)Overloaded. 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. (Defined by Enumerable.)
Public Extension MethodGroupBy<TEntity, TKey, TElement, TResult>(Expression<Func<TEntity, TKey>>, Expression<Func<TEntity, TElement>>, Expression<Func<TKey, IEnumerable<TElement>, TResult>>, IEqualityComparer<TKey>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodGroupBy<TEntity, TKey, TElement, TResult>(Func<TEntity, TKey>, Func<TEntity, TElement>, Func<TKey, IEnumerable<TElement>, TResult>, IEqualityComparer<TKey>)Overloaded. Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. Key values are compared by using a specified comparer, and the elements of each group are projected by using a specified function. (Defined by Enumerable.)
Public Extension MethodGroupJoin<TEntity, TInner, TKey, TResult>(IEnumerable<TInner>, Expression<Func<TEntity, TKey>>, Expression<Func<TInner, TKey>>, Expression<Func<TEntity, IEnumerable<TInner>, TResult>>)Overloaded. Correlates the elements of two sequences based on key equality and groups the results. The default equality comparer is used to compare keys. (Defined by Queryable.)
Public Extension MethodGroupJoin<TEntity, TInner, TKey, TResult>(IEnumerable<TInner>, Func<TEntity, TKey>, Func<TInner, TKey>, Func<TEntity, IEnumerable<TInner>, TResult>)Overloaded. Correlates the elements of two sequences based on equality of keys and groups the results. The default equality comparer is used to compare keys. (Defined by Enumerable.)
Public Extension MethodGroupJoin<TEntity, TInner, TKey, TResult>(IEnumerable<TInner>, Expression<Func<TEntity, TKey>>, Expression<Func<TInner, TKey>>, Expression<Func<TEntity, IEnumerable<TInner>, TResult>>, IEqualityComparer<TKey>)Overloaded. Correlates the elements of two sequences based on key equality and groups the results. A specified IEqualityComparer<T> is used to compare keys. (Defined by Queryable.)
Public Extension MethodGroupJoin<TEntity, TInner, TKey, TResult>(IEnumerable<TInner>, Func<TEntity, TKey>, Func<TInner, TKey>, Func<TEntity, IEnumerable<TInner>, TResult>, IEqualityComparer<TKey>)Overloaded. Correlates the elements of two sequences based on key equality and groups the results. A specified IEqualityComparer<T> is used to compare keys. (Defined by Enumerable.)
Public Extension MethodIntersect<TEntity>(IEnumerable<TEntity>)Overloaded. Produces the set intersection of two sequences by using the default equality comparer to compare values. (Defined by Queryable.)
Public Extension MethodIntersect<TEntity>(IEnumerable<TEntity>)Overloaded. Produces the set intersection of two sequences by using the default equality comparer to compare values. (Defined by Enumerable.)
Public Extension MethodIntersect<TEntity>(IEnumerable<TEntity>, IEqualityComparer<TEntity>)Overloaded. Produces the set intersection of two sequences by using the specified IEqualityComparer<T> to compare values. (Defined by Queryable.)
Public Extension MethodIntersect<TEntity>(IEnumerable<TEntity>, IEqualityComparer<TEntity>)Overloaded. Produces the set intersection of two sequences by using the specified IEqualityComparer<T> to compare values. (Defined by Enumerable.)
Public Extension MethodJoin<TEntity, TInner, TKey, TResult>(IEnumerable<TInner>, Expression<Func<TEntity, TKey>>, Expression<Func<TInner, TKey>>, Expression<Func<TEntity, TInner, TResult>>)Overloaded. Correlates the elements of two sequences based on matching keys. The default equality comparer is used to compare keys. (Defined by Queryable.)
Public Extension MethodJoin<TEntity, TInner, TKey, TResult>(IEnumerable<TInner>, Func<TEntity, TKey>, Func<TInner, TKey>, Func<TEntity, TInner, TResult>)Overloaded. Correlates the elements of two sequences based on matching keys. The default equality comparer is used to compare keys. (Defined by Enumerable.)
Public Extension MethodJoin<TEntity, TInner, TKey, TResult>(IEnumerable<TInner>, Expression<Func<TEntity, TKey>>, Expression<Func<TInner, TKey>>, Expression<Func<TEntity, TInner, TResult>>, IEqualityComparer<TKey>)Overloaded. Correlates the elements of two sequences based on matching keys. A specified IEqualityComparer<T> is used to compare keys. (Defined by Queryable.)
Public Extension MethodJoin<TEntity, TInner, TKey, TResult>(IEnumerable<TInner>, Func<TEntity, TKey>, Func<TInner, TKey>, Func<TEntity, TInner, TResult>, IEqualityComparer<TKey>)Overloaded. Correlates the elements of two sequences based on matching keys. A specified IEqualityComparer<T> is used to compare keys. (Defined by Enumerable.)
Public Extension MethodLast<TEntity>()Overloaded. Returns the last element in a sequence. (Defined by Queryable.)
Public Extension MethodLast<TEntity>()Overloaded. Returns the last element of a sequence. (Defined by Enumerable.)
Public Extension MethodLast<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. Returns the last element of a sequence that satisfies a specified condition. (Defined by Queryable.)
Public Extension MethodLast<TEntity>(Func<TEntity, Boolean>)Overloaded. Returns the last element of a sequence that satisfies a specified condition. (Defined by Enumerable.)
Public Extension MethodLastOrDefault<TEntity>()Overloaded. Returns the last element in a sequence, or a default value if the sequence contains no elements. (Defined by Queryable.)
Public Extension MethodLastOrDefault<TEntity>()Overloaded. Returns the last element of a sequence, or a default value if the sequence contains no elements. (Defined by Enumerable.)
Public Extension MethodLastOrDefault<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. Returns the last element of a sequence that satisfies a condition or a default value if no such element is found. (Defined by Queryable.)
Public Extension MethodLastOrDefault<TEntity>(Func<TEntity, Boolean>)Overloaded. Returns the last element of a sequence that satisfies a condition or a default value if no such element is found. (Defined by Enumerable.)
Public Extension MethodLongCount<TEntity>()Overloaded. Returns an Int64 that represents the total number of elements in a sequence. (Defined by Queryable.)
Public Extension MethodLongCount<TEntity>()Overloaded. Returns an Int64 that represents the total number of elements in a sequence. (Defined by Enumerable.)
Public Extension MethodLongCount<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. Returns an Int64 that represents the number of elements in a sequence that satisfy a condition. (Defined by Queryable.)
Public Extension MethodLongCount<TEntity>(Func<TEntity, Boolean>)Overloaded. Returns an Int64 that represents how many elements in a sequence satisfy a condition. (Defined by Enumerable.)
Public Extension MethodMax<TEntity>()Overloaded. Returns the maximum value in a generic IQueryable<T>. (Defined by Queryable.)
Public Extension MethodMax<TEntity>()Overloaded. Returns the maximum value in a generic sequence. (Defined by Enumerable.)
Public Extension MethodMax<TEntity>(Func<TEntity, Decimal>)Overloaded. Invokes a transform function on each element of a sequence and returns the maximum Decimal value. (Defined by Enumerable.)
Public Extension MethodMax<TEntity>(Func<TEntity, Nullable<Decimal>>)Overloaded. Invokes a transform function on each element of a sequence and returns the maximum nullable Decimal value. (Defined by Enumerable.)
Public Extension MethodMax<TEntity>(Func<TEntity, Double>)Overloaded. Invokes a transform function on each element of a sequence and returns the maximum Double value. (Defined by Enumerable.)
Public Extension MethodMax<TEntity>(Func<TEntity, Nullable<Double>>)Overloaded. Invokes a transform function on each element of a sequence and returns the maximum nullable Double value. (Defined by Enumerable.)
Public Extension MethodMax<TEntity>(Func<TEntity, Int32>)Overloaded. Invokes a transform function on each element of a sequence and returns the maximum Int32 value. (Defined by Enumerable.)
Public Extension MethodMax<TEntity>(Func<TEntity, Nullable<Int32>>)Overloaded. Invokes a transform function on each element of a sequence and returns the maximum nullable Int32 value. (Defined by Enumerable.)
Public Extension MethodMax<TEntity>(Func<TEntity, Int64>)Overloaded. Invokes a transform function on each element of a sequence and returns the maximum Int64 value. (Defined by Enumerable.)
Public Extension MethodMax<TEntity>(Func<TEntity, Nullable<Int64>>)Overloaded. Invokes a transform function on each element of a sequence and returns the maximum nullable Int64 value. (Defined by Enumerable.)
Public Extension MethodMax<TEntity>(Func<TEntity, Single>)Overloaded. Invokes a transform function on each element of a sequence and returns the maximum Single value. (Defined by Enumerable.)
Public Extension MethodMax<TEntity>(Func<TEntity, Nullable<Single>>)Overloaded. Invokes a transform function on each element of a sequence and returns the maximum nullable Single value. (Defined by Enumerable.)
Public Extension MethodMax<TEntity, TResult>(Expression<Func<TEntity, TResult>>)Overloaded. Invokes a projection function on each element of a generic IQueryable<T> and returns the maximum resulting value. (Defined by Queryable.)
Public Extension MethodMax<TEntity, TResult>(Func<TEntity, TResult>)Overloaded. Invokes a transform function on each element of a generic sequence and returns the maximum resulting value. (Defined by Enumerable.)
Public Extension MethodMin<TEntity>()Overloaded. Returns the minimum value of a generic IQueryable<T>. (Defined by Queryable.)
Public Extension MethodMin<TEntity>()Overloaded. Returns the minimum value in a generic sequence. (Defined by Enumerable.)
Public Extension MethodMin<TEntity>(Func<TEntity, Decimal>)Overloaded. Invokes a transform function on each element of a sequence and returns the minimum Decimal value. (Defined by Enumerable.)
Public Extension MethodMin<TEntity>(Func<TEntity, Nullable<Decimal>>)Overloaded. Invokes a transform function on each element of a sequence and returns the minimum nullable Decimal value. (Defined by Enumerable.)
Public Extension MethodMin<TEntity>(Func<TEntity, Double>)Overloaded. Invokes a transform function on each element of a sequence and returns the minimum Double value. (Defined by Enumerable.)
Public Extension MethodMin<TEntity>(Func<TEntity, Nullable<Double>>)Overloaded. Invokes a transform function on each element of a sequence and returns the minimum nullable Double value. (Defined by Enumerable.)
Public Extension MethodMin<TEntity>(Func<TEntity, Int32>)Overloaded. Invokes a transform function on each element of a sequence and returns the minimum Int32 value. (Defined by Enumerable.)
Public Extension MethodMin<TEntity>(Func<TEntity, Nullable<Int32>>)Overloaded. Invokes a transform function on each element of a sequence and returns the minimum nullable Int32 value. (Defined by Enumerable.)
Public Extension MethodMin<TEntity>(Func<TEntity, Int64>)Overloaded. Invokes a transform function on each element of a sequence and returns the minimum Int64 value. (Defined by Enumerable.)
Public Extension MethodMin<TEntity>(Func<TEntity, Nullable<Int64>>)Overloaded. Invokes a transform function on each element of a sequence and returns the minimum nullable Int64 value. (Defined by Enumerable.)
Public Extension MethodMin<TEntity>(Func<TEntity, Single>)Overloaded. Invokes a transform function on each element of a sequence and returns the minimum Single value. (Defined by Enumerable.)
Public Extension MethodMin<TEntity>(Func<TEntity, Nullable<Single>>)Overloaded. Invokes a transform function on each element of a sequence and returns the minimum nullable Single value. (Defined by Enumerable.)
Public Extension MethodMin<TEntity, TResult>(Expression<Func<TEntity, TResult>>)Overloaded. Invokes a projection function on each element of a generic IQueryable<T> and returns the minimum resulting value. (Defined by Queryable.)
Public Extension MethodMin<TEntity, TResult>(Func<TEntity, TResult>)Overloaded. Invokes a transform function on each element of a generic sequence and returns the minimum resulting value. (Defined by Enumerable.)
Public Extension MethodOfType<TResult>()Overloaded. Filters the elements of an IQueryable based on a specified type. (Defined by Queryable.)
Public Extension MethodOfType<TResult>()Overloaded. Filters the elements of an IEnumerable based on a specified type. (Defined by Enumerable.)
Public Extension MethodOrderBy<TEntity, TKey>(Expression<Func<TEntity, TKey>>)Overloaded. Sorts the elements of a sequence in ascending order according to a key. (Defined by Queryable.)
Public Extension MethodOrderBy<TEntity, TKey>(Func<TEntity, TKey>)Overloaded. Sorts the elements of a sequence in ascending order according to a key. (Defined by Enumerable.)
Public Extension MethodOrderBy<TEntity, TKey>(Expression<Func<TEntity, TKey>>, IComparer<TKey>)Overloaded. Sorts the elements of a sequence in ascending order by using a specified comparer. (Defined by Queryable.)
Public Extension MethodOrderBy<TEntity, TKey>(Func<TEntity, TKey>, IComparer<TKey>)Overloaded. Sorts the elements of a sequence in ascending order by using a specified comparer. (Defined by Enumerable.)
Public Extension MethodOrderByDescending<TEntity, TKey>(Expression<Func<TEntity, TKey>>)Overloaded. Sorts the elements of a sequence in descending order according to a key. (Defined by Queryable.)
Public Extension MethodOrderByDescending<TEntity, TKey>(Func<TEntity, TKey>)Overloaded. Sorts the elements of a sequence in descending order according to a key. (Defined by Enumerable.)
Public Extension MethodOrderByDescending<TEntity, TKey>(Expression<Func<TEntity, TKey>>, IComparer<TKey>)Overloaded. Sorts the elements of a sequence in descending order by using a specified comparer. (Defined by Queryable.)
Public Extension MethodOrderByDescending<TEntity, TKey>(Func<TEntity, TKey>, IComparer<TKey>)Overloaded. Sorts the elements of a sequence in descending order by using a specified comparer. (Defined by Enumerable.)
Public Extension MethodReverse<TEntity>()Overloaded. Inverts the order of the elements in a sequence. (Defined by Queryable.)
Public Extension MethodReverse<TEntity>()Overloaded. Inverts the order of the elements in a sequence. (Defined by Enumerable.)
Public Extension MethodSelect<TEntity, TResult>(Expression<Func<TEntity, TResult>>)Overloaded. Projects each element of a sequence into a new form. (Defined by Queryable.)
Public Extension MethodSelect<TEntity, TResult>(Expression<Func<TEntity, Int32, TResult>>)Overloaded. Projects each element of a sequence into a new form by incorporating the element's index. (Defined by Queryable.)
Public Extension MethodSelect<TEntity, TResult>(Func<TEntity, TResult>)Overloaded. Projects each element of a sequence into a new form. (Defined by Enumerable.)
Public Extension MethodSelect<TEntity, TResult>(Func<TEntity, Int32, TResult>)Overloaded. Projects each element of a sequence into a new form by incorporating the element's index. (Defined by Enumerable.)
Public Extension MethodSelectMany<TEntity, TResult>(Expression<Func<TEntity, IEnumerable<TResult>>>)Overloaded. Projects each element of a sequence to an IEnumerable<T> and combines the resulting sequences into one sequence. (Defined by Queryable.)
Public Extension MethodSelectMany<TEntity, TResult>(Expression<Func<TEntity, Int32, IEnumerable<TResult>>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodSelectMany<TEntity, TResult>(Func<TEntity, IEnumerable<TResult>>)Overloaded. Projects each element of a sequence to an IEnumerable<T> and flattens the resulting sequences into one sequence. (Defined by Enumerable.)
Public Extension MethodSelectMany<TEntity, TResult>(Func<TEntity, Int32, IEnumerable<TResult>>)Overloaded. Projects each element of a sequence to an IEnumerable<T>, and flattens the resulting sequences into one sequence. The index of each source element is used in the projected form of that element. (Defined by Enumerable.)
Public Extension MethodSelectMany<TEntity, TCollection, TResult>(Expression<Func<TEntity, Int32, IEnumerable<TCollection>>>, Expression<Func<TEntity, TCollection, TResult>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodSelectMany<TEntity, TCollection, TResult>(Expression<Func<TEntity, IEnumerable<TCollection>>>, Expression<Func<TEntity, TCollection, TResult>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodSelectMany<TEntity, TCollection, TResult>(Func<TEntity, Int32, IEnumerable<TCollection>>, Func<TEntity, TCollection, TResult>)Overloaded. Projects each element of a sequence to an IEnumerable<T>, flattens the resulting sequences into one sequence, and invokes a result selector function on each element therein. The index of each source element is used in the intermediate projected form of that element. (Defined by Enumerable.)
Public Extension MethodSelectMany<TEntity, TCollection, TResult>(Func<TEntity, IEnumerable<TCollection>>, Func<TEntity, TCollection, TResult>)Overloaded. Projects each element of a sequence to an IEnumerable<T>, flattens the resulting sequences into one sequence, and invokes a result selector function on each element therein. (Defined by Enumerable.)
Public Extension MethodSequenceEqual<TEntity>(IEnumerable<TEntity>)Overloaded. Determines whether two sequences are equal by using the default equality comparer to compare elements. (Defined by Queryable.)
Public Extension MethodSequenceEqual<TEntity>(IEnumerable<TEntity>)Overloaded. Determines whether two sequences are equal by comparing the elements by using the default equality comparer for their type. (Defined by Enumerable.)
Public Extension MethodSequenceEqual<TEntity>(IEnumerable<TEntity>, IEqualityComparer<TEntity>)Overloaded. Determines whether two sequences are equal by using a specified IEqualityComparer<T> to compare elements. (Defined by Queryable.)
Public Extension MethodSequenceEqual<TEntity>(IEnumerable<TEntity>, IEqualityComparer<TEntity>)Overloaded. Determines whether two sequences are equal by comparing their elements by using a specified IEqualityComparer<T>. (Defined by Enumerable.)
Public Extension MethodSingle<TEntity>()Overloaded. Returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence. (Defined by Queryable.)
Public Extension MethodSingle<TEntity>()Overloaded. Returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence. (Defined by Enumerable.)
Public Extension MethodSingle<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. Returns the only element of a sequence that satisfies a specified condition, and throws an exception if more than one such element exists. (Defined by Queryable.)
Public Extension MethodSingle<TEntity>(Func<TEntity, Boolean>)Overloaded. Returns the only element of a sequence that satisfies a specified condition, and throws an exception if more than one such element exists. (Defined by Enumerable.)
Public Extension MethodSingleOrDefault<TEntity>()Overloaded. 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. (Defined by Queryable.)
Public Extension MethodSingleOrDefault<TEntity>()Overloaded. 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. (Defined by Enumerable.)
Public Extension MethodSingleOrDefault<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodSingleOrDefault<TEntity>(Func<TEntity, Boolean>)Overloaded. 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. (Defined by Enumerable.)
Public Extension MethodSkip<TEntity>(Int32)Overloaded. Bypasses a specified number of elements in a sequence and then returns the remaining elements. (Defined by Queryable.)
Public Extension MethodSkip<TEntity>(Int32)Overloaded. Bypasses a specified number of elements in a sequence and then returns the remaining elements. (Defined by Enumerable.)
Public Extension MethodSkipWhile<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements. (Defined by Queryable.)
Public Extension MethodSkipWhile<TEntity>(Func<TEntity, Boolean>)Overloaded. Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements. (Defined by Enumerable.)
Public Extension MethodSkipWhile<TEntity>(Expression<Func<TEntity, Int32, Boolean>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodSkipWhile<TEntity>(Func<TEntity, Int32, Boolean>)Overloaded. 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. (Defined by Enumerable.)
Public Extension MethodSortBy<TEntity>Specifies a sort order. (Defined by QueryExtensions.)
Public Extension MethodSum<TEntity>(Expression<Func<TEntity, Decimal>>)Overloaded. Computes the sum of the sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence. (Defined by Queryable.)
Public Extension MethodSum<TEntity>(Expression<Func<TEntity, Nullable<Decimal>>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodSum<TEntity>(Func<TEntity, Decimal>)Overloaded. Computes the sum of the sequence of Decimal values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodSum<TEntity>(Func<TEntity, Nullable<Decimal>>)Overloaded. Computes the sum of the sequence of nullable Decimal values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodSum<TEntity>(Expression<Func<TEntity, Double>>)Overloaded. Computes the sum of the sequence of Double values that is obtained by invoking a projection function on each element of the input sequence. (Defined by Queryable.)
Public Extension MethodSum<TEntity>(Expression<Func<TEntity, Nullable<Double>>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodSum<TEntity>(Func<TEntity, Double>)Overloaded. Computes the sum of the sequence of Double values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodSum<TEntity>(Func<TEntity, Nullable<Double>>)Overloaded. Computes the sum of the sequence of nullable Double values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodSum<TEntity>(Expression<Func<TEntity, Int32>>)Overloaded. Computes the sum of the sequence of Int32 values that is obtained by invoking a projection function on each element of the input sequence. (Defined by Queryable.)
Public Extension MethodSum<TEntity>(Expression<Func<TEntity, Nullable<Int32>>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodSum<TEntity>(Expression<Func<TEntity, Int64>>)Overloaded. Computes the sum of the sequence of Int64 values that is obtained by invoking a projection function on each element of the input sequence. (Defined by Queryable.)
Public Extension MethodSum<TEntity>(Expression<Func<TEntity, Nullable<Int64>>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodSum<TEntity>(Expression<Func<TEntity, Single>>)Overloaded. Computes the sum of the sequence of Single values that is obtained by invoking a projection function on each element of the input sequence. (Defined by Queryable.)
Public Extension MethodSum<TEntity>(Expression<Func<TEntity, Nullable<Single>>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodSum<TEntity>(Func<TEntity, Int32>)Overloaded. Computes the sum of the sequence of Int32 values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodSum<TEntity>(Func<TEntity, Nullable<Int32>>)Overloaded. Computes the sum of the sequence of nullable Int32 values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodSum<TEntity>(Func<TEntity, Int64>)Overloaded. Computes the sum of the sequence of Int64 values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodSum<TEntity>(Func<TEntity, Nullable<Int64>>)Overloaded. Computes the sum of the sequence of nullable Int64 values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodSum<TEntity>(Func<TEntity, Single>)Overloaded. Computes the sum of the sequence of Single values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodSum<TEntity>(Func<TEntity, Nullable<Single>>)Overloaded. Computes the sum of the sequence of nullable Single values that are obtained by invoking a transform function on each element of the input sequence. (Defined by Enumerable.)
Public Extension MethodTake<TEntity>(Int32)Overloaded. Returns a specified number of contiguous elements from the start of a sequence. (Defined by Queryable.)
Public Extension MethodTake<TEntity>(Int32)Overloaded. Returns a specified number of contiguous elements from the start of a sequence. (Defined by Enumerable.)
Public Extension MethodTakeWhile<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. Returns elements from a sequence as long as a specified condition is true. (Defined by Queryable.)
Public Extension MethodTakeWhile<TEntity>(Func<TEntity, Boolean>)Overloaded. Returns elements from a sequence as long as a specified condition is true. (Defined by Enumerable.)
Public Extension MethodTakeWhile<TEntity>(Expression<Func<TEntity, Int32, Boolean>>)Overloaded. 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. (Defined by Queryable.)
Public Extension MethodTakeWhile<TEntity>(Func<TEntity, Int32, Boolean>)Overloaded. 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. (Defined by Enumerable.)
Public Extension MethodToArray<TEntity>Creates an array from a IEnumerable<T>. (Defined by Enumerable.)
Public Extension MethodToDictionary<TEntity, TKey>(Func<TEntity, TKey>)Overloaded. Creates a Dictionary<TKey, TValue> from an IEnumerable<T> according to a specified key selector function. (Defined by Enumerable.)
Public Extension MethodToDictionary<TEntity, TKey>(Func<TEntity, TKey>, IEqualityComparer<TKey>)Overloaded. Creates a Dictionary<TKey, TValue> from an IEnumerable<T> according to a specified key selector function and key comparer. (Defined by Enumerable.)
Public Extension MethodToDictionary<TEntity, TKey, TElement>(Func<TEntity, TKey>, Func<TEntity, TElement>)Overloaded. Creates a Dictionary<TKey, TValue> from an IEnumerable<T> according to specified key selector and element selector functions. (Defined by Enumerable.)
Public Extension MethodToDictionary<TEntity, TKey, TElement>(Func<TEntity, TKey>, Func<TEntity, TElement>, IEqualityComparer<TKey>)Overloaded. Creates a Dictionary<TKey, TValue> from an IEnumerable<T> according to a specified key selector function, a comparer, and an element selector function. (Defined by Enumerable.)
Public Extension MethodToList<TEntity>Creates a List<T> from an IEnumerable<T>. (Defined by Enumerable.)
Public Extension MethodToLookup<TEntity, TKey>(Func<TEntity, TKey>)Overloaded. Creates a Lookup<TKey, TElement> from an IEnumerable<T> according to a specified key selector function. (Defined by Enumerable.)
Public Extension MethodToLookup<TEntity, TKey>(Func<TEntity, TKey>, IEqualityComparer<TKey>)Overloaded. Creates a Lookup<TKey, TElement> from an IEnumerable<T> according to a specified key selector function and key comparer. (Defined by Enumerable.)
Public Extension MethodToLookup<TEntity, TKey, TElement>(Func<TEntity, TKey>, Func<TEntity, TElement>)Overloaded. Creates a Lookup<TKey, TElement> from an IEnumerable<T> according to specified key selector and element selector functions. (Defined by Enumerable.)
Public Extension MethodToLookup<TEntity, TKey, TElement>(Func<TEntity, TKey>, Func<TEntity, TElement>, IEqualityComparer<TKey>)Overloaded. Creates a Lookup<TKey, TElement> from an IEnumerable<T> according to a specified key selector function, a comparer and an element selector function. (Defined by Enumerable.)
Public Extension MethodUnion<TEntity>(IEnumerable<TEntity>)Overloaded. Produces the set union of two sequences by using the default equality comparer. (Defined by Queryable.)
Public Extension MethodUnion<TEntity>(IEnumerable<TEntity>)Overloaded. Produces the set union of two sequences by using the default equality comparer. (Defined by Enumerable.)
Public Extension MethodUnion<TEntity>(IEnumerable<TEntity>, IEqualityComparer<TEntity>)Overloaded. Produces the set union of two sequences by using a specified IEqualityComparer<T>. (Defined by Queryable.)
Public Extension MethodUnion<TEntity>(IEnumerable<TEntity>, IEqualityComparer<TEntity>)Overloaded. Produces the set union of two sequences by using a specified IEqualityComparer<T>. (Defined by Enumerable.)
Public Extension MethodWhere<TEntity>(Expression<Func<TEntity, Boolean>>)Overloaded. Filters a sequence of values based on a predicate. (Defined by Queryable.)
Public Extension MethodWhere<TEntity>(Func<TEntity, Boolean>)Overloaded. Filters a sequence of values based on a predicate. (Defined by Enumerable.)
Public Extension MethodWhere<TEntity>(Expression<Func<TEntity, Int32, Boolean>>)Overloaded. Filters a sequence of values based on a predicate. Each element's index is used in the logic of the predicate function. (Defined by Queryable.)
Public Extension MethodWhere<TEntity>(Func<TEntity, Int32, Boolean>)Overloaded. Filters a sequence of values based on a predicate. Each element's index is used in the logic of the predicate function. (Defined by Enumerable.)
Public Extension MethodZip<TEntity, TSecond, TResult>(IEnumerable<TSecond>, Expression<Func<TEntity, TSecond, TResult>>)Overloaded. Merges two sequences by using the specified predicate function. (Defined by Queryable.)
Public Extension MethodZip<TEntity, TSecond, TResult>(IEnumerable<TSecond>, Func<TEntity, TSecond, TResult>)Overloaded. Applies a specified function to the corresponding elements of two sequences, producing a sequence of the results. (Defined by Enumerable.)
Top
  NameDescription
Explicit interface implemetationPrivate methodIEnumerable<TEntity>.GetEnumeratorReturns an enumerator that iterates through the collection.
Explicit interface implemetationPrivate methodIEnumerable.GetEnumeratorReturns an enumerator that iterates through the collection.
Explicit interface implemetationPrivate propertyIListSource.ContainsListCollectionGets a value that indicates whether the collection is a collection of IList objects.
Explicit interface implemetationPrivate methodIListSource.GetListReturns an IList that can be bound to a data source from an object that does not implement an IList itself.
Explicit interface implemetationPrivate propertyIQueryable.ElementTypeGets the type of the element(s) that are returned when the expression tree associated with this object is executed.
Explicit interface implemetationPrivate propertyIQueryable.ExpressionGets the expression tree that is associated with this instance of IQueryable.
Explicit interface implemetationPrivate propertyIQueryable.ProviderGets the query provider that is associated with this data source.
Explicit interface implemetationPrivate methodIQueryProvider.CreateQuery(Expression)Constructs an IQueryable object that can evaluate the query represented by a specified expression tree.
Explicit interface implemetationPrivate methodIQueryProvider.CreateQuery<TResult>(Expression)Constructs an IQueryable<T> object that can evaluate the query represented by a specified expression tree.
Explicit interface implemetationPrivate methodIQueryProvider.Execute(Expression)Executes the query represented by a specified expression tree.
Explicit interface implemetationPrivate methodIQueryProvider.Execute<TResult>(Expression)Executes the strongly-typed query represented by a specified expression tree.
Explicit interface implemetationPrivate methodITable.Attach(Object)Attaches an entity to the DataContext in an unmodified state.
Explicit interface implemetationPrivate methodITable.Attach(Object, Boolean)Attaches all entities of a collection to the DataContext in either a modified or unmodified state.
Explicit interface implemetationPrivate methodITable.Attach(Object, Object)Attaches an entity to the DataContext in either a modified or unmodified state by specifying both the entity and its original state.
Explicit interface implemetationPrivate methodITable.AttachAll(IEnumerable)Attaches all entities of a collection to the DataContext in either a modified or unmodified state.
Explicit interface implemetationPrivate methodITable.AttachAll(IEnumerable, Boolean)Attaches all entities of a collection to the DataContext in either a modified or unmodified state.
Explicit interface implemetationPrivate methodITable.DeleteAllOnSubmitPuts all entities from the collection into a pending delete state.
Explicit interface implemetationPrivate methodITable.DeleteOnSubmitPuts an entity from this table into a pending delete state.
Explicit interface implemetationPrivate methodITable.GetModifiedMembersReturns an array of modified members that contain their current and original values.
Explicit interface implemetationPrivate methodITable.GetOriginalEntityStateRetrieves original values of a given entity.
Explicit interface implemetationPrivate methodITable.InsertAllOnSubmitAdds all entities of a collection to the DataContext in an pending insert state.
Explicit interface implemetationPrivate methodITable.InsertOnSubmitAdds an entity in a pending insert state to this table.
Top

This class enables you to query over the table and add, remove, and attach objects.

An application can access a Table<TEntity> instance via GetTable or by using a strongly typed property for the strongly typed DataContext. That is, when the designer generates a DataContext object, it generates properties to represent each Table. For example:

[global::System.Data.Linq.Mapping.DatabaseAttribute(Name="SignOffTool")]
public partial class DataClasses1DataContext : System.Data.Linq.DataContext {
   public System.Data.Linq.Table<User> Users {
      get {
         return this.GetTable<User>();
      }
   }
}

For this strongly typed DataContext, you can access the Users property to get Table<User>.

.NET Framework

Supported in: 4.5.1, 4.5, 4, 3.5

.NET Framework Client Profile

Supported in: 4

Windows Phone 8.1, Windows Phone 8, Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.