Table(TEntity) Class

Table<TEntity> Class

 

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

Namespace:   System.Data.Linq
Assembly:  System.Data.Linq (in System.Data.Linq.dll)

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

public sealed class Table<TEntity> : IQueryable<TEntity>, IEnumerable<TEntity>, 
	IEnumerable, IQueryable, IQueryProvider, ITable, IListSource, 
	ITable<TEntity>
where TEntity : class

Type Parameters

TEntity

The type of the data in the table.

NameDescription
System_CAPS_pubpropertyContext

Gets the DataContext that has been used to retrieve this Table<TEntity>.

System_CAPS_pubpropertyIsReadOnly

Gets a value that indicates whether the type of the entities contained in this Table<TEntity> instance has a primary key.

NameDescription
System_CAPS_pubmethodAttach(TEntity)

Attaches a disconnected or "detached" entity to a new DataContext when original values are required for optimistic concurrency checks.

System_CAPS_pubmethodAttach(TEntity, TEntity)

Attaches an entity to the DataContext in either a modified or unmodified state by specifying both the entity and its original state.

System_CAPS_pubmethodAttach(TEntity, Boolean)

Attaches an entity to the DataContext in either a modified or unmodified state.

System_CAPS_pubmethodAttachAll<TSubEntity>(IEnumerable<TSubEntity>)

Attaches all entities of a collection to the DataContext in either a modified or unmodified state.

System_CAPS_pubmethodAttachAll<TSubEntity>(IEnumerable<TSubEntity>, Boolean)

Attaches all entities of a collection to the DataContext in either a modified or unmodified state.

System_CAPS_pubmethodDeleteAllOnSubmit<TSubEntity>(IEnumerable<TSubEntity>)

Puts all entities from the collection into a pending delete state.

System_CAPS_pubmethodDeleteOnSubmit(TEntity)

Puts an entity from this table into a pending delete state.

System_CAPS_pubmethodEquals(Object)

Determines whether the specified object is equal to the current object.(Inherited from Object.)

System_CAPS_pubmethodGetEnumerator()

Gets an enumerator that iterates through the collection.

System_CAPS_pubmethodGetHashCode()

Serves as the default hash function. (Inherited from Object.)

System_CAPS_pubmethodGetModifiedMembers(TEntity)

Returns an array of modified members that contain their current and original values.

System_CAPS_pubmethodGetNewBindingList()

Creates a new list for binding to a data source.

System_CAPS_pubmethodGetOriginalEntityState(TEntity)

Returns a Table<TEntity> instance that contains the original state of the entity.

System_CAPS_pubmethodGetType()

Gets the Type of the current instance.(Inherited from Object.)

System_CAPS_pubmethodInsertAllOnSubmit<TSubEntity>(IEnumerable<TSubEntity>)

Adds all entities of a collection to the DataContext in a pending insert state.

System_CAPS_pubmethodInsertOnSubmit(TEntity)

Adds an entity in a pending insert state to this Table<TEntity>.

System_CAPS_pubmethodToString()

Returns a string that represents the table.(Overrides Object.ToString().)

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privmethodIEnumerable<TEntity>.GetEnumerator()

Returns an enumerator that iterates through the collection.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIEnumerable.GetEnumerator()

Returns an enumerator that iterates through the collection.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIListSource.GetList()

Returns an IList that can be bound to a data source from an object that does not implement an IList itself.

System_CAPS_pubinterfaceSystem_CAPS_privmethodITable.Attach(Object)

Attaches an entity to the DataContext in an unmodified state.

System_CAPS_pubinterfaceSystem_CAPS_privmethodITable.Attach(Object, Boolean)

Attaches all entities of a collection to the DataContext in either a modified or unmodified state.

System_CAPS_pubinterfaceSystem_CAPS_privmethodITable.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.

System_CAPS_pubinterfaceSystem_CAPS_privmethodITable.AttachAll(IEnumerable)

Attaches all entities of a collection to the DataContext in either a modified or unmodified state.

System_CAPS_pubinterfaceSystem_CAPS_privmethodITable.AttachAll(IEnumerable, Boolean)

Attaches all entities of a collection to the DataContext in either a modified or unmodified state.

System_CAPS_pubinterfaceSystem_CAPS_privmethodITable.DeleteAllOnSubmit(IEnumerable)

Puts all entities from the collection into a pending delete state.

System_CAPS_pubinterfaceSystem_CAPS_privmethodITable.DeleteOnSubmit(Object)

Puts an entity from this table into a pending delete state.

System_CAPS_pubinterfaceSystem_CAPS_privmethodITable.GetModifiedMembers(Object)

Returns an array of modified members that contain their current and original values.

System_CAPS_pubinterfaceSystem_CAPS_privmethodITable.GetOriginalEntityState(Object)

Retrieves original values of a given entity.

System_CAPS_pubinterfaceSystem_CAPS_privmethodITable.InsertAllOnSubmit(IEnumerable)

Adds all entities of a collection to the DataContext in an pending insert state.

System_CAPS_pubinterfaceSystem_CAPS_privmethodITable.InsertOnSubmit(Object)

Adds an entity in a pending insert state to this table.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIQueryProvider.CreateQuery(Expression)

Constructs an IQueryable object that can evaluate the query represented by a specified expression tree.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIQueryProvider.CreateQuery<TResult>(Expression)

Constructs an IQueryable<T> object that can evaluate the query represented by a specified expression tree.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIQueryProvider.Execute(Expression)

Executes the query represented by a specified expression tree.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIQueryProvider.Execute<TResult>(Expression)

Executes the strongly-typed query represented by a specified expression tree.

System_CAPS_pubinterfaceSystem_CAPS_privpropertyIListSource.ContainsListCollection

Gets a value that indicates whether the collection is a collection of IList objects.

System_CAPS_pubinterfaceSystem_CAPS_privpropertyIQueryable.ElementType

Gets the type of the element(s) that are returned when the expression tree associated with this object is executed.

System_CAPS_pubinterfaceSystem_CAPS_privpropertyIQueryable.Expression

Gets the expression tree that is associated with this instance of IQueryable.

System_CAPS_pubinterfaceSystem_CAPS_privpropertyIQueryable.Provider

Gets the query provider that is associated with this data source.

NameDescription
System_CAPS_pubmethodAggregate<TEntity>(Func<TEntity, TEntity, TEntity>)

Overloaded. Applies an accumulator function over a sequence.(Defined by Enumerable.)

System_CAPS_pubmethodAggregate<TEntity>(Expression<Func<TEntity, TEntity, TEntity>>)

Overloaded. Applies an accumulator function over a sequence.(Defined by Queryable.)

System_CAPS_pubmethodAggregate<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.)

System_CAPS_pubmethodAggregate<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.)

System_CAPS_pubmethodAggregate<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.)

System_CAPS_pubmethodAggregate<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.)

System_CAPS_pubmethodAll<TEntity>(Func<TEntity, Boolean>)

Determines whether all elements of a sequence satisfy a condition.(Defined by Enumerable.)

System_CAPS_pubmethodAll<TEntity>(Expression<Func<TEntity, Boolean>>)

Determines whether all the elements of a sequence satisfy a condition.(Defined by Queryable.)

System_CAPS_pubmethodAny<TEntity>()

Overloaded. Determines whether a sequence contains any elements.(Defined by Enumerable.)

System_CAPS_pubmethodAny<TEntity>(Func<TEntity, Boolean>)

Overloaded. Determines whether any element of a sequence satisfies a condition.(Defined by Enumerable.)

System_CAPS_pubmethodAny<TEntity>()

Overloaded. Determines whether a sequence contains any elements.(Defined by Queryable.)

System_CAPS_pubmethodAny<TEntity>(Expression<Func<TEntity, Boolean>>)

Overloaded. Determines whether any element of a sequence satisfies a condition.(Defined by Queryable.)

System_CAPS_pubmethodAsEnumerable<TEntity>()

Returns the input typed as IEnumerable<T>.(Defined by Enumerable.)

System_CAPS_pubmethodAsParallel()

Overloaded. Enables parallelization of a query.(Defined by ParallelEnumerable.)

System_CAPS_pubmethodAsParallel<TEntity>()

Overloaded. Enables parallelization of a query.(Defined by ParallelEnumerable.)

System_CAPS_pubmethodAsQueryable()

Overloaded. Converts an IEnumerable to an IQueryable.(Defined by Queryable.)

System_CAPS_pubmethodAsQueryable<TEntity>()

Overloaded. Converts a generic IEnumerable<T> to a generic IQueryable<T>.(Defined by Queryable.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodAverage<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.)

System_CAPS_pubmethodCast<TResult>()

Casts the elements of an IEnumerable to the specified type.(Defined by Enumerable.)

System_CAPS_pubmethodConcat<TEntity>(IEnumerable<TEntity>)

Concatenates two sequences.(Defined by Enumerable.)

System_CAPS_pubmethodConcat<TEntity>(IEnumerable<TEntity>)

Concatenates two sequences.(Defined by Queryable.)

System_CAPS_pubmethodContains<TEntity>(TEntity)

Overloaded. Determines whether a sequence contains a specified element by using the default equality comparer.(Defined by Enumerable.)

System_CAPS_pubmethodContains<TEntity>(TEntity, IEqualityComparer<TEntity>)

Overloaded. Determines whether a sequence contains a specified element by using a specified IEqualityComparer<T>.(Defined by Enumerable.)

System_CAPS_pubmethodContains<TEntity>(TEntity)

Overloaded. Determines whether a sequence contains a specified element by using the default equality comparer.(Defined by Queryable.)

System_CAPS_pubmethodContains<TEntity>(TEntity, IEqualityComparer<TEntity>)

Overloaded. Determines whether a sequence contains a specified element by using a specified IEqualityComparer<T>.(Defined by Queryable.)

System_CAPS_pubmethodCount<TEntity>()

Overloaded. Returns the number of elements in a sequence.(Defined by Enumerable.)

System_CAPS_pubmethodCount<TEntity>(Func<TEntity, Boolean>)

Overloaded. Returns a number that represents how many elements in the specified sequence satisfy a condition.(Defined by Enumerable.)

System_CAPS_pubmethodCount<TEntity>()

Overloaded. Returns the number of elements in a sequence.(Defined by Queryable.)

System_CAPS_pubmethodCount<TEntity>(Expression<Func<TEntity, Boolean>>)

Overloaded. Returns the number of elements in the specified sequence that satisfies a condition.(Defined by Queryable.)

System_CAPS_pubmethodDefaultIfEmpty<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.)

System_CAPS_pubmethodDefaultIfEmpty<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.)

System_CAPS_pubmethodDefaultIfEmpty<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.)

System_CAPS_pubmethodDefaultIfEmpty<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.)

System_CAPS_pubmethodDistinct<TEntity>()

Overloaded. Returns distinct elements from a sequence by using the default equality comparer to compare values.(Defined by Enumerable.)

System_CAPS_pubmethodDistinct<TEntity>(IEqualityComparer<TEntity>)

Overloaded. Returns distinct elements from a sequence by using a specified IEqualityComparer<T> to compare values.(Defined by Enumerable.)

System_CAPS_pubmethodDistinct<TEntity>()

Overloaded. Returns distinct elements from a sequence by using the default equality comparer to compare values.(Defined by Queryable.)

System_CAPS_pubmethodDistinct<TEntity>(IEqualityComparer<TEntity>)

Overloaded. Returns distinct elements from a sequence by using a specified IEqualityComparer<T> to compare values.(Defined by Queryable.)

System_CAPS_pubmethodElementAt<TEntity>(Int32)

Returns the element at a specified index in a sequence.(Defined by Enumerable.)

System_CAPS_pubmethodElementAt<TEntity>(Int32)

Returns the element at a specified index in a sequence.(Defined by Queryable.)

System_CAPS_pubmethodElementAtOrDefault<TEntity>(Int32)

Returns the element at a specified index in a sequence or a default value if the index is out of range.(Defined by Enumerable.)

System_CAPS_pubmethodElementAtOrDefault<TEntity>(Int32)

Returns the element at a specified index in a sequence or a default value if the index is out of range.(Defined by Queryable.)

System_CAPS_pubmethodExcept<TEntity>(IEnumerable<TEntity>)

Overloaded. Produces the set difference of two sequences by using the default equality comparer to compare values.(Defined by Enumerable.)

System_CAPS_pubmethodExcept<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.)

System_CAPS_pubmethodExcept<TEntity>(IEnumerable<TEntity>)

Overloaded. Produces the set difference of two sequences by using the default equality comparer to compare values.(Defined by Queryable.)

System_CAPS_pubmethodExcept<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.)

System_CAPS_pubmethodFirst<TEntity>()

Overloaded. Returns the first element of a sequence.(Defined by Enumerable.)

System_CAPS_pubmethodFirst<TEntity>(Func<TEntity, Boolean>)

Overloaded. Returns the first element in a sequence that satisfies a specified condition.(Defined by Enumerable.)

System_CAPS_pubmethodFirst<TEntity>()

Overloaded. Returns the first element of a sequence.(Defined by Queryable.)

System_CAPS_pubmethodFirst<TEntity>(Expression<Func<TEntity, Boolean>>)

Overloaded. Returns the first element of a sequence that satisfies a specified condition.(Defined by Queryable.)

System_CAPS_pubmethodFirstOrDefault<TEntity>()

Overloaded. Returns the first element of a sequence, or a default value if the sequence contains no elements.(Defined by Enumerable.)

System_CAPS_pubmethodFirstOrDefault<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.)

System_CAPS_pubmethodFirstOrDefault<TEntity>()

Overloaded. Returns the first element of a sequence, or a default value if the sequence contains no elements.(Defined by Queryable.)

System_CAPS_pubmethodFirstOrDefault<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.)

System_CAPS_pubmethodGroupBy<TEntity, TKey>(Func<TEntity, TKey>)

Overloaded. Groups the elements of a sequence according to a specified key selector function.(Defined by Enumerable.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<TEntity, TKey>(Expression<Func<TEntity, TKey>>)

Overloaded. Groups the elements of a sequence according to a specified key selector function.(Defined by Queryable.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupBy<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.)

System_CAPS_pubmethodGroupJoin<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.)

System_CAPS_pubmethodGroupJoin<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.)

System_CAPS_pubmethodGroupJoin<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.)

System_CAPS_pubmethodGroupJoin<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.)

System_CAPS_pubmethodIntersect<TEntity>(IEnumerable<TEntity>)

Overloaded. Produces the set intersection of two sequences by using the default equality comparer to compare values.(Defined by Enumerable.)

System_CAPS_pubmethodIntersect<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.)

System_CAPS_pubmethodIntersect<TEntity>(IEnumerable<TEntity>)

Overloaded. Produces the set intersection of two sequences by using the default equality comparer to compare values.(Defined by Queryable.)

System_CAPS_pubmethodIntersect<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.)

System_CAPS_pubmethodJoin<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.)

System_CAPS_pubmethodJoin<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.)

System_CAPS_pubmethodJoin<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.)

System_CAPS_pubmethodJoin<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.)

System_CAPS_pubmethodLast<TEntity>()

Overloaded. Returns the last element of a sequence.(Defined by Enumerable.)

System_CAPS_pubmethodLast<TEntity>(Func<TEntity, Boolean>)

Overloaded. Returns the last element of a sequence that satisfies a specified condition.(Defined by Enumerable.)

System_CAPS_pubmethodLast<TEntity>()

Overloaded. Returns the last element in a sequence.(Defined by Queryable.)

System_CAPS_pubmethodLast<TEntity>(Expression<Func<TEntity, Boolean>>)

Overloaded. Returns the last element of a sequence that satisfies a specified condition.(Defined by Queryable.)

System_CAPS_pubmethodLastOrDefault<TEntity>()

Overloaded. Returns the last element of a sequence, or a default value if the sequence contains no elements.(Defined by Enumerable.)

System_CAPS_pubmethodLastOrDefault<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.)

System_CAPS_pubmethodLastOrDefault<TEntity>()

Overloaded. Returns the last element in a sequence, or a default value if the sequence contains no elements.(Defined by Queryable.)

System_CAPS_pubmethodLastOrDefault<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.)

System_CAPS_pubmethodLongCount<TEntity>()

Overloaded. Returns an Int64 that represents the total number of elements in a sequence.(Defined by Enumerable.)

System_CAPS_pubmethodLongCount<TEntity>(Func<TEntity, Boolean>)

Overloaded. Returns an Int64 that represents how many elements in a sequence satisfy a condition.(Defined by Enumerable.)

System_CAPS_pubmethodLongCount<TEntity>()

Overloaded. Returns an Int64 that represents the total number of elements in a sequence.(Defined by Queryable.)

System_CAPS_pubmethodLongCount<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.)

System_CAPS_pubmethodMax<TEntity>()

Overloaded. Returns the maximum value in a generic sequence.(Defined by Enumerable.)

System_CAPS_pubmethodMax<TEntity>(Func<TEntity, Decimal>)

Overloaded. Invokes a transform function on each element of a sequence and returns the maximum Decimal value.(Defined by Enumerable.)

System_CAPS_pubmethodMax<TEntity>(Func<TEntity, Double>)

Overloaded. Invokes a transform function on each element of a sequence and returns the maximum Double value.(Defined by Enumerable.)

System_CAPS_pubmethodMax<TEntity>(Func<TEntity, Int32>)

Overloaded. Invokes a transform function on each element of a sequence and returns the maximum Int32 value.(Defined by Enumerable.)

System_CAPS_pubmethodMax<TEntity>(Func<TEntity, Int64>)

Overloaded. Invokes a transform function on each element of a sequence and returns the maximum Int64 value.(Defined by Enumerable.)

System_CAPS_pubmethodMax<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.)

System_CAPS_pubmethodMax<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.)

System_CAPS_pubmethodMax<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.)

System_CAPS_pubmethodMax<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.)

System_CAPS_pubmethodMax<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.)

System_CAPS_pubmethodMax<TEntity>(Func<TEntity, Single>)

Overloaded. Invokes a transform function on each element of a sequence and returns the maximum Single value.(Defined by Enumerable.)

System_CAPS_pubmethodMax<TEntity>()

Overloaded. Returns the maximum value in a generic IQueryable<T>.(Defined by Queryable.)

System_CAPS_pubmethodMax<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.)

System_CAPS_pubmethodMax<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.)

System_CAPS_pubmethodMin<TEntity>()

Overloaded. Returns the minimum value in a generic sequence.(Defined by Enumerable.)

System_CAPS_pubmethodMin<TEntity>(Func<TEntity, Decimal>)

Overloaded. Invokes a transform function on each element of a sequence and returns the minimum Decimal value.(Defined by Enumerable.)

System_CAPS_pubmethodMin<TEntity>(Func<TEntity, Double>)

Overloaded. Invokes a transform function on each element of a sequence and returns the minimum Double value.(Defined by Enumerable.)

System_CAPS_pubmethodMin<TEntity>(Func<TEntity, Int32>)

Overloaded. Invokes a transform function on each element of a sequence and returns the minimum Int32 value.(Defined by Enumerable.)

System_CAPS_pubmethodMin<TEntity>(Func<TEntity, Int64>)

Overloaded. Invokes a transform function on each element of a sequence and returns the minimum Int64 value.(Defined by Enumerable.)

System_CAPS_pubmethodMin<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.)

System_CAPS_pubmethodMin<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.)

System_CAPS_pubmethodMin<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.)

System_CAPS_pubmethodMin<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.)

System_CAPS_pubmethodMin<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.)

System_CAPS_pubmethodMin<TEntity>(Func<TEntity, Single>)

Overloaded. Invokes a transform function on each element of a sequence and returns the minimum Single value.(Defined by Enumerable.)

System_CAPS_pubmethodMin<TEntity>()

Overloaded. Returns the minimum value of a generic IQueryable<T>.(Defined by Queryable.)

System_CAPS_pubmethodMin<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.)

System_CAPS_pubmethodMin<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.)

System_CAPS_pubmethodOfType<TResult>()

Filters the elements of an IEnumerable based on a specified type.(Defined by Enumerable.)

System_CAPS_pubmethodOrderBy<TEntity, TKey>(Func<TEntity, TKey>)

Overloaded. Sorts the elements of a sequence in ascending order according to a key.(Defined by Enumerable.)

System_CAPS_pubmethodOrderBy<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.)

System_CAPS_pubmethodOrderBy<TEntity, TKey>(Expression<Func<TEntity, TKey>>)

Overloaded. Sorts the elements of a sequence in ascending order according to a key.(Defined by Queryable.)

System_CAPS_pubmethodOrderBy<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.)

System_CAPS_pubmethodOrderByDescending<TEntity, TKey>(Func<TEntity, TKey>)

Overloaded. Sorts the elements of a sequence in descending order according to a key.(Defined by Enumerable.)

System_CAPS_pubmethodOrderByDescending<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.)

System_CAPS_pubmethodOrderByDescending<TEntity, TKey>(Expression<Func<TEntity, TKey>>)

Overloaded. Sorts the elements of a sequence in descending order according to a key.(Defined by Queryable.)

System_CAPS_pubmethodOrderByDescending<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.)

System_CAPS_pubmethodReverse<TEntity>()

Inverts the order of the elements in a sequence.(Defined by Enumerable.)

System_CAPS_pubmethodReverse<TEntity>()

Inverts the order of the elements in a sequence.(Defined by Queryable.)

System_CAPS_pubmethodSelect<TEntity, TResult>(Func<TEntity, TResult>)

Overloaded. Projects each element of a sequence into a new form.(Defined by Enumerable.)

System_CAPS_pubmethodSelect<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.)

System_CAPS_pubmethodSelect<TEntity, TResult>(Expression<Func<TEntity, TResult>>)

Overloaded. Projects each element of a sequence into a new form.(Defined by Queryable.)

System_CAPS_pubmethodSelect<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.)

System_CAPS_pubmethodSelectMany<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.)

System_CAPS_pubmethodSelectMany<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.)

System_CAPS_pubmethodSelectMany<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.)

System_CAPS_pubmethodSelectMany<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.)

System_CAPS_pubmethodSelectMany<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.)

System_CAPS_pubmethodSelectMany<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.)

System_CAPS_pubmethodSelectMany<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.)

System_CAPS_pubmethodSelectMany<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.)

System_CAPS_pubmethodSequenceEqual<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.)

System_CAPS_pubmethodSequenceEqual<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.)

System_CAPS_pubmethodSequenceEqual<TEntity>(IEnumerable<TEntity>)

Overloaded. Determines whether two sequences are equal by using the default equality comparer to compare elements.(Defined by Queryable.)

System_CAPS_pubmethodSequenceEqual<TEntity>(IEnumerable<TEntity>, IEqualityComparer<TEntity>)

Overloaded. Determines whether two sequences are equal by using a specified IEqualityComparer<T> to compare elements.(Defined by Queryable.)

System_CAPS_pubmethodSingle<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.)

System_CAPS_pubmethodSingle<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.)

System_CAPS_pubmethodSingle<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.)

System_CAPS_pubmethodSingle<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.)

System_CAPS_pubmethodSingleOrDefault<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.)

System_CAPS_pubmethodSingleOrDefault<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.)

System_CAPS_pubmethodSingleOrDefault<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.)

System_CAPS_pubmethodSingleOrDefault<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.)

System_CAPS_pubmethodSkip<TEntity>(Int32)

Bypasses a specified number of elements in a sequence and then returns the remaining elements.(Defined by Enumerable.)

System_CAPS_pubmethodSkip<TEntity>(Int32)

Bypasses a specified number of elements in a sequence and then returns the remaining elements.(Defined by Queryable.)

System_CAPS_pubmethodSkipWhile<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.)

System_CAPS_pubmethodSkipWhile<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.)

System_CAPS_pubmethodSkipWhile<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.)

System_CAPS_pubmethodSkipWhile<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.)

System_CAPS_pubmethodSortBy<TEntity>(String)

Specifies a sort order.(Defined by QueryExtensions.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodSum<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.)

System_CAPS_pubmethodTake<TEntity>(Int32)

Returns a specified number of contiguous elements from the start of a sequence.(Defined by Enumerable.)

System_CAPS_pubmethodTake<TEntity>(Int32)

Returns a specified number of contiguous elements from the start of a sequence.(Defined by Queryable.)

System_CAPS_pubmethodTakeWhile<TEntity>(Func<TEntity, Boolean>)

Overloaded. Returns elements from a sequence as long as a specified condition is true.(Defined by Enumerable.)

System_CAPS_pubmethodTakeWhile<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.)

System_CAPS_pubmethodTakeWhile<TEntity>(Expression<Func<TEntity, Boolean>>)

Overloaded. Returns elements from a sequence as long as a specified condition is true.(Defined by Queryable.)

System_CAPS_pubmethodTakeWhile<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.)

System_CAPS_pubmethodToArray<TEntity>()

Creates an array from a IEnumerable<T>.(Defined by Enumerable.)

System_CAPS_pubmethodToDictionary<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.)

System_CAPS_pubmethodToDictionary<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.)

System_CAPS_pubmethodToDictionary<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.)

System_CAPS_pubmethodToDictionary<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.)

System_CAPS_pubmethodToList<TEntity>()

Creates a List<T> from an IEnumerable<T>.(Defined by Enumerable.)

System_CAPS_pubmethodToLookup<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.)

System_CAPS_pubmethodToLookup<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.)

System_CAPS_pubmethodToLookup<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.)

System_CAPS_pubmethodToLookup<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.)

System_CAPS_pubmethodUnion<TEntity>(IEnumerable<TEntity>)

Overloaded. Produces the set union of two sequences by using the default equality comparer.(Defined by Enumerable.)

System_CAPS_pubmethodUnion<TEntity>(IEnumerable<TEntity>, IEqualityComparer<TEntity>)

Overloaded. Produces the set union of two sequences by using a specified IEqualityComparer<T>.(Defined by Enumerable.)

System_CAPS_pubmethodUnion<TEntity>(IEnumerable<TEntity>)

Overloaded. Produces the set union of two sequences by using the default equality comparer.(Defined by Queryable.)

System_CAPS_pubmethodUnion<TEntity>(IEnumerable<TEntity>, IEqualityComparer<TEntity>)

Overloaded. Produces the set union of two sequences by using a specified IEqualityComparer<T>.(Defined by Queryable.)

System_CAPS_pubmethodWhere<TEntity>(Func<TEntity, Boolean>)

Overloaded. Filters a sequence of values based on a predicate.(Defined by Enumerable.)

System_CAPS_pubmethodWhere<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.)

System_CAPS_pubmethodWhere<TEntity>(Expression<Func<TEntity, Boolean>>)

Overloaded. Filters a sequence of values based on a predicate.(Defined by Queryable.)

System_CAPS_pubmethodWhere<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.)

System_CAPS_pubmethodZip<TEntity, TSecond, TResult>(IEnumerable<TSecond>, Func<TEntity, TSecond, TResult>)

Applies a specified function to the corresponding elements of two sequences, producing a sequence of the results.(Defined by Enumerable.)

System_CAPS_pubmethodZip<TEntity, TSecond, TResult>(IEnumerable<TSecond>, Expression<Func<TEntity, TSecond, TResult>>)

Merges two sequences by using the specified predicate function.(Defined by Queryable.)

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<TEntity> 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
Available since 3.5
Windows Phone Silverlight
Available since 7.1

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show:
© 2016 Microsoft