Queryable Queryable Queryable Queryable Class

定義

提供一組static(Shared Visual Basic 中) 方法來查詢資料結構實作IQueryable<T>Provides a set of static (Shared in Visual Basic) methods for querying data structures that implement IQueryable<T>.

public ref class Queryable abstract sealed
public static class Queryable
type Queryable = class
Public Module Queryable
繼承
QueryableQueryableQueryableQueryable

備註

中的一組方法宣告Queryable查詢的資料來源實作類別提供的標準查詢運算子實作IQueryable<T>The set of methods declared in the Queryable class provides an implementation of the standard query operators for querying data sources that implement IQueryable<T>. 標準查詢運算子會遵循的一般用途方法LINQLINQ模式,並讓您透過任何表示周遊、 篩選和投射作業。以.NET 為基礎的程式設計語言。The standard query operators are general purpose methods that follow the LINQLINQ pattern and enable you to express traversal, filter, and projection operations over data in any .NET-based programming language.

此類別中方法大多會定義為延伸的延伸模組方法IQueryable<T>型別。The majority of the methods in this class are defined as extension methods that extend the IQueryable<T> type. 這表示它們可以實作任何物件上呼叫和執行個體方法一樣IQueryable<T>This means they can be called like an instance method on any object that implements IQueryable<T>. 這些方法來擴充IQueryable<T>不會執行任何直接查詢。These methods that extend IQueryable<T> do not perform any querying directly. 相反地,其功能是建置Expression物件,即表示累計查詢的運算式樹狀架構。Instead, their functionality is to build an Expression object, which is an expression tree that represents the cumulative query. 方法接著會將新的運算式樹狀架構傳遞給其中一個Execute<TResult>(Expression)方法或CreateQuery<TElement>(Expression)方法的輸入IQueryable<T>The methods then pass the new expression tree to either the Execute<TResult>(Expression) method or the CreateQuery<TElement>(Expression) method of the input IQueryable<T>. 呼叫的方法取決於是否Queryable方法會傳回單一值,在此情況下Execute<TResult>(Expression)呼叫時,或可列舉結果,在此情況下CreateQuery<TElement>(Expression)呼叫。The method that is called depends on whether the Queryable method returns a singleton value, in which case Execute<TResult>(Expression) is called, or has enumerable results, in which case CreateQuery<TElement>(Expression) is called.

目標資料上執行實際的查詢藉由實作類別IQueryable<T>The actual query execution on the target data is performed by a class that implements IQueryable<T>. 任何預期IQueryable<T>實作是執行運算式樹狀架構所建構的結果Queryable標準查詢運算子方法就相當於呼叫對應方法的結果Enumerable類別,如果資料來源是IEnumerable<T>The expectation of any IQueryable<T> implementation is that the result of executing an expression tree that was constructed by a Queryable standard query operator method is equivalent to the result of calling the corresponding method in the Enumerable class, if the data source were an IEnumerable<T>.

除了運作的標準查詢運算子方法IQueryable<T>物件,這個類別也包含一個方法中, AsQueryable,哪一個型別IEnumerable物件做為IQueryable物件。In addition to the standard query operator methods that operate on IQueryable<T> objects, this class also contains a method, AsQueryable, which types IEnumerable objects as IQueryable objects.

方法

Aggregate<TSource,TAccumulate,TResult>(IQueryable<TSource>, TAccumulate, Expression<Func<TAccumulate,TSource,TAccumulate>>, Expression<Func<TAccumulate,TResult>>) Aggregate<TSource,TAccumulate,TResult>(IQueryable<TSource>, TAccumulate, Expression<Func<TAccumulate,TSource,TAccumulate>>, Expression<Func<TAccumulate,TResult>>) Aggregate<TSource,TAccumulate,TResult>(IQueryable<TSource>, TAccumulate, Expression<Func<TAccumulate,TSource,TAccumulate>>, Expression<Func<TAccumulate,TResult>>) Aggregate<TSource,TAccumulate,TResult>(IQueryable<TSource>, TAccumulate, Expression<Func<TAccumulate,TSource,TAccumulate>>, Expression<Func<TAccumulate,TResult>>)

套用到序列的累加函式。Applies an accumulator function over a sequence. 使用指定的值做為初始累加值,並使用指定的函式來選取結果值。The specified seed value is used as the initial accumulator value, and the specified function is used to select the result value.

Aggregate<TSource,TAccumulate>(IQueryable<TSource>, TAccumulate, Expression<Func<TAccumulate,TSource,TAccumulate>>) Aggregate<TSource,TAccumulate>(IQueryable<TSource>, TAccumulate, Expression<Func<TAccumulate,TSource,TAccumulate>>) Aggregate<TSource,TAccumulate>(IQueryable<TSource>, TAccumulate, Expression<Func<TAccumulate,TSource,TAccumulate>>) Aggregate<TSource,TAccumulate>(IQueryable<TSource>, TAccumulate, Expression<Func<TAccumulate,TSource,TAccumulate>>)

套用到序列的累加函式。Applies an accumulator function over a sequence. 使用指定的初始值做為初始累加值。The specified seed value is used as the initial accumulator value.

Aggregate<TSource>(IQueryable<TSource>, Expression<Func<TSource,TSource,TSource>>) Aggregate<TSource>(IQueryable<TSource>, Expression<Func<TSource,TSource,TSource>>) Aggregate<TSource>(IQueryable<TSource>, Expression<Func<TSource,TSource,TSource>>) Aggregate<TSource>(IQueryable<TSource>, Expression<Func<TSource,TSource,TSource>>)

套用到序列的累加函式。Applies an accumulator function over a sequence.

All<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) All<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) All<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) All<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

判斷序列中的所有項目是否全都符合條件。Determines whether all the elements of a sequence satisfy a condition.

Any<TSource>(IQueryable<TSource>) Any<TSource>(IQueryable<TSource>) Any<TSource>(IQueryable<TSource>) Any<TSource>(IQueryable<TSource>)

判斷序列是否包含任何項目。Determines whether a sequence contains any elements.

Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Any<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

判斷序列的任何項目是否符合條件。Determines whether any element of a sequence satisfies a condition.

Append<TSource>(IQueryable<TSource>, TSource) Append<TSource>(IQueryable<TSource>, TSource) Append<TSource>(IQueryable<TSource>, TSource) Append<TSource>(IQueryable<TSource>, TSource)
AsQueryable(IEnumerable) AsQueryable(IEnumerable) AsQueryable(IEnumerable) AsQueryable(IEnumerable)

將轉換IEnumerableIQueryableConverts an IEnumerable to an IQueryable.

AsQueryable<TElement>(IEnumerable<TElement>) AsQueryable<TElement>(IEnumerable<TElement>) AsQueryable<TElement>(IEnumerable<TElement>) AsQueryable<TElement>(IEnumerable<TElement>)

將轉換為泛型IEnumerable<T>成泛型IQueryable<T>Converts a generic IEnumerable<T> to a generic IQueryable<T>.

Average(IQueryable<Single>) Average(IQueryable<Single>) Average(IQueryable<Single>) Average(IQueryable<Single>)

計算序列的平均值Single值。Computes the average of a sequence of Single values.

Average(IQueryable<Nullable<Single>>) Average(IQueryable<Nullable<Single>>) Average(IQueryable<Nullable<Single>>) Average(IQueryable<Nullable<Single>>)

計算可為 Null 之 Single 值序列的平均值。Computes the average of a sequence of nullable Single values.

Average(IQueryable<Nullable<Int64>>) Average(IQueryable<Nullable<Int64>>) Average(IQueryable<Nullable<Int64>>) Average(IQueryable<Nullable<Int64>>)

計算可為 Null 之 Int64 值序列的平均值。Computes the average of a sequence of nullable Int64 values.

Average(IQueryable<Nullable<Double>>) Average(IQueryable<Nullable<Double>>) Average(IQueryable<Nullable<Double>>) Average(IQueryable<Nullable<Double>>)

計算可為 Null 之 Double 值序列的平均值。Computes the average of a sequence of nullable Double values.

Average(IQueryable<Nullable<Int32>>) Average(IQueryable<Nullable<Int32>>) Average(IQueryable<Nullable<Int32>>) Average(IQueryable<Nullable<Int32>>)

計算可為 Null 之 Int32 值序列的平均值。Computes the average of a sequence of nullable Int32 values.

Average(IQueryable<Int64>) Average(IQueryable<Int64>) Average(IQueryable<Int64>) Average(IQueryable<Int64>)

計算序列的平均值Int64值。Computes the average of a sequence of Int64 values.

Average(IQueryable<Int32>) Average(IQueryable<Int32>) Average(IQueryable<Int32>) Average(IQueryable<Int32>)

計算序列的平均值Int32值。Computes the average of a sequence of Int32 values.

Average(IQueryable<Double>) Average(IQueryable<Double>) Average(IQueryable<Double>) Average(IQueryable<Double>)

計算序列的平均值Double值。Computes the average of a sequence of Double values.

Average(IQueryable<Decimal>) Average(IQueryable<Decimal>) Average(IQueryable<Decimal>) Average(IQueryable<Decimal>)

計算序列的平均值Decimal值。Computes the average of a sequence of Decimal values.

Average(IQueryable<Nullable<Decimal>>) Average(IQueryable<Nullable<Decimal>>) Average(IQueryable<Nullable<Decimal>>) Average(IQueryable<Nullable<Decimal>>)

計算可為 Null 之 Decimal 值序列的平均值。Computes the average of a sequence of nullable Decimal values.

Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>)

計算序列的平均值Single叫用投影函式的輸入序列的每個項目所取得的值。Computes the average of a sequence of Single values that is obtained by invoking a projection function on each element of the input sequence.

Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>)

計算可為 null 的序列的平均值Single叫用投影函式的輸入序列的每個項目所取得的值。Computes the average of a sequence of nullable Single values that is obtained by invoking a projection function on each element of the input sequence.

Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>)

計算可為 null 的序列的平均值Int64叫用投影函式的輸入序列的每個項目所取得的值。Computes the average of a sequence of nullable Int64 values that is obtained by invoking a projection function on each element of the input sequence.

Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>)

計算可為 null 的序列的平均值Int32叫用投影函式的輸入序列的每個項目所取得的值。Computes the average of a sequence of nullable Int32 values that is obtained by invoking a projection function on each element of the input sequence.

Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>)

計算可為 null 的序列的平均值Double叫用投影函式的輸入序列的每個項目所取得的值。Computes the average of a sequence of nullable Double values that is obtained by invoking a projection function on each element of the input sequence.

Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>)

計算序列的平均值Int64叫用投影函式的輸入序列的每個項目所取得的值。Computes the average of a sequence of Int64 values that is obtained by invoking a projection function on each element of the input sequence.

Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>)

計算序列的平均值Int32叫用投影函式的輸入序列的每個項目所取得的值。Computes the average of a sequence of Int32 values that is obtained by invoking a projection function on each element of the input sequence.

Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)

計算序列的平均值Double叫用投影函式的輸入序列的每個項目所取得的值。Computes the average of a sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.

Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>)

計算序列的平均值Decimal叫用投影函式的輸入序列的每個項目所取得的值。Computes the average of a sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.

Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>) Average<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>)

計算可為 null 的序列的平均值Decimal叫用投影函式的輸入序列的每個項目所取得的值。Computes the average of a sequence of nullable Decimal values that is obtained by invoking a projection function on each element of the input sequence.

Cast<TResult>(IQueryable) Cast<TResult>(IQueryable) Cast<TResult>(IQueryable) Cast<TResult>(IQueryable)

IQueryable 的項目轉換為指定的型別。Converts the elements of an IQueryable to the specified type.

Concat<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Concat<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Concat<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Concat<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

串連兩個序列。Concatenates two sequences.

Contains<TSource>(IQueryable<TSource>, TSource, IEqualityComparer<TSource>) Contains<TSource>(IQueryable<TSource>, TSource, IEqualityComparer<TSource>) Contains<TSource>(IQueryable<TSource>, TSource, IEqualityComparer<TSource>) Contains<TSource>(IQueryable<TSource>, TSource, IEqualityComparer<TSource>)

判斷序列是否包含指定的項目,使用指定的IEqualityComparer<T>Determines whether a sequence contains a specified element by using a specified IEqualityComparer<T>.

Contains<TSource>(IQueryable<TSource>, TSource) Contains<TSource>(IQueryable<TSource>, TSource) Contains<TSource>(IQueryable<TSource>, TSource) Contains<TSource>(IQueryable<TSource>, TSource)

判斷序列是否包含指定的項目,使用預設相等比較子。Determines whether a sequence contains a specified element by using the default equality comparer.

Count<TSource>(IQueryable<TSource>) Count<TSource>(IQueryable<TSource>) Count<TSource>(IQueryable<TSource>) Count<TSource>(IQueryable<TSource>)

傳回序列中的項目數目。Returns the number of elements in a sequence.

Count<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Count<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Count<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Count<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

指定符合條件的順序傳回項目數目。Returns the number of elements in the specified sequence that satisfies a condition.

DefaultIfEmpty<TSource>(IQueryable<TSource>) DefaultIfEmpty<TSource>(IQueryable<TSource>) DefaultIfEmpty<TSource>(IQueryable<TSource>) DefaultIfEmpty<TSource>(IQueryable<TSource>)

如果序列是空的傳回單一集合中指定的順序或型別參數的預設值的項目。Returns the elements of the specified sequence or the type parameter's default value in a singleton collection if the sequence is empty.

DefaultIfEmpty<TSource>(IQueryable<TSource>, TSource) DefaultIfEmpty<TSource>(IQueryable<TSource>, TSource) DefaultIfEmpty<TSource>(IQueryable<TSource>, TSource) DefaultIfEmpty<TSource>(IQueryable<TSource>, TSource)

如果序列是空的傳回單一集合中指定的序列或指定的值的項目。Returns the elements of the specified sequence or the specified value in a singleton collection if the sequence is empty.

Distinct<TSource>(IQueryable<TSource>) Distinct<TSource>(IQueryable<TSource>) Distinct<TSource>(IQueryable<TSource>) Distinct<TSource>(IQueryable<TSource>)

使用預設相等比較子來比較值,從序列傳回獨特的項目。Returns distinct elements from a sequence by using the default equality comparer to compare values.

Distinct<TSource>(IQueryable<TSource>, IEqualityComparer<TSource>) Distinct<TSource>(IQueryable<TSource>, IEqualityComparer<TSource>) Distinct<TSource>(IQueryable<TSource>, IEqualityComparer<TSource>) Distinct<TSource>(IQueryable<TSource>, IEqualityComparer<TSource>)

從序列傳回獨特的項目,使用指定的IEqualityComparer<T>來比較值。Returns distinct elements from a sequence by using a specified IEqualityComparer<T> to compare values.

ElementAt<TSource>(IQueryable<TSource>, Int32) ElementAt<TSource>(IQueryable<TSource>, Int32) ElementAt<TSource>(IQueryable<TSource>, Int32) ElementAt<TSource>(IQueryable<TSource>, Int32)

傳回序列中的指定索引處的項目。Returns the element at a specified index in a sequence.

ElementAtOrDefault<TSource>(IQueryable<TSource>, Int32) ElementAtOrDefault<TSource>(IQueryable<TSource>, Int32) ElementAtOrDefault<TSource>(IQueryable<TSource>, Int32) ElementAtOrDefault<TSource>(IQueryable<TSource>, Int32)

傳回位於序列中指定索引處的元素;如果索引超出範圍,則傳回預設值。Returns the element at a specified index in a sequence or a default value if the index is out of range.

Except<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Except<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Except<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Except<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>)

使用指定的產生兩個序列的差異IEqualityComparer<T>來比較值。Produces the set difference of two sequences by using the specified IEqualityComparer<T> to compare values.

Except<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Except<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Except<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Except<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

使用預設相等比較子來比較值,以便產生兩個序列的集合差異。Produces the set difference of two sequences by using the default equality comparer to compare values.

First<TSource>(IQueryable<TSource>) First<TSource>(IQueryable<TSource>) First<TSource>(IQueryable<TSource>) First<TSource>(IQueryable<TSource>)

傳回序列的第一個項目。Returns the first element of a sequence.

First<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) First<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) First<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) First<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

傳回序列中符合指定的條件的第一個項目。Returns the first element of a sequence that satisfies a specified condition.

FirstOrDefault<TSource>(IQueryable<TSource>) FirstOrDefault<TSource>(IQueryable<TSource>) FirstOrDefault<TSource>(IQueryable<TSource>) FirstOrDefault<TSource>(IQueryable<TSource>)

傳回序列的第一個元素;如果序列中沒有包含任何元素,則傳回預設值。Returns the first element of a sequence, or a default value if the sequence contains no elements.

FirstOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) FirstOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) FirstOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) FirstOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

傳回序列中符合指定的條件或預設值,如果找不到任何這類項目是第一個項目。Returns the first element of a sequence that satisfies a specified condition or a default value if no such element is found.

GroupBy<TSource,TKey,TElement,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>, Expression<Func<TKey,IEnumerable<TElement>,TResult>>, IEqualityComparer<TKey>) GroupBy<TSource,TKey,TElement,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>, Expression<Func<TKey,IEnumerable<TElement>,TResult>>, IEqualityComparer<TKey>) GroupBy<TSource,TKey,TElement,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>, Expression<Func<TKey,IEnumerable<TElement>,TResult>>, IEqualityComparer<TKey>) GroupBy<TSource,TKey,TElement,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>, Expression<Func<TKey,IEnumerable<TElement>,TResult>>, IEqualityComparer<TKey>)

依據指定的索引鍵選取器函式來群組序列的項目,並從每個群組及其索引鍵建立結果值。Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. 使用指定的比較子來比較索引鍵,是利用指定的函式進行投影每個群組的項目。Keys are compared by using a specified comparer and the elements of each group are projected by using a specified function.

GroupBy<TSource,TKey,TElement,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>, Expression<Func<TKey,IEnumerable<TElement>,TResult>>) GroupBy<TSource,TKey,TElement,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>, Expression<Func<TKey,IEnumerable<TElement>,TResult>>) GroupBy<TSource,TKey,TElement,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>, Expression<Func<TKey,IEnumerable<TElement>,TResult>>) GroupBy<TSource,TKey,TElement,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>, Expression<Func<TKey,IEnumerable<TElement>,TResult>>)

依據指定的索引鍵選取器函式來群組序列的項目,並從每個群組及其索引鍵建立結果值。Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. 每個群組的項目都是利用指定的函式進行投影。The elements of each group are projected by using a specified function.

GroupBy<TSource,TKey,TElement>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>) GroupBy<TSource,TKey,TElement>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>) GroupBy<TSource,TKey,TElement>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>) GroupBy<TSource,TKey,TElement>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>)

群組根據指定的索引鍵選取器函式,以及專案使用指定的函式的每個群組的項目序列的項目。Groups the elements of a sequence according to a specified key selector function and projects the elements for each group by using a specified function.

GroupBy<TSource,TKey,TElement>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>, IEqualityComparer<TKey>) GroupBy<TSource,TKey,TElement>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>, IEqualityComparer<TKey>) GroupBy<TSource,TKey,TElement>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>, IEqualityComparer<TKey>) GroupBy<TSource,TKey,TElement>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TSource,TElement>>, IEqualityComparer<TKey>)

使用指定的函式來分組序列的項目並為每個群組的項目。Groups the elements of a sequence and projects the elements for each group by using a specified function. 使用指定的比較子來比較索引鍵的值。Key values are compared by using a specified comparer.

GroupBy<TSource,TKey,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TKey,IEnumerable<TSource>,TResult>>) GroupBy<TSource,TKey,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TKey,IEnumerable<TSource>,TResult>>) GroupBy<TSource,TKey,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TKey,IEnumerable<TSource>,TResult>>) GroupBy<TSource,TKey,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TKey,IEnumerable<TSource>,TResult>>)

依據指定的索引鍵選取器函式來群組序列的項目,並從每個群組及其索引鍵建立結果值。Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key.

GroupBy<TSource,TKey,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TKey,IEnumerable<TSource>,TResult>>, IEqualityComparer<TKey>) GroupBy<TSource,TKey,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TKey,IEnumerable<TSource>,TResult>>, IEqualityComparer<TKey>) GroupBy<TSource,TKey,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TKey,IEnumerable<TSource>,TResult>>, IEqualityComparer<TKey>) GroupBy<TSource,TKey,TResult>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, Expression<Func<TKey,IEnumerable<TSource>,TResult>>, IEqualityComparer<TKey>)

依據指定的索引鍵選取器函式來群組序列的項目,並從每個群組及其索引鍵建立結果值。Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. 使用指定的比較子來比較索引鍵。Keys are compared by using a specified comparer.

GroupBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, IEqualityComparer<TKey>) GroupBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, IEqualityComparer<TKey>) GroupBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, IEqualityComparer<TKey>) GroupBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, IEqualityComparer<TKey>)

群組的順序,根據指定的索引鍵選取器函式和比較使用指定的比較子索引鍵的項目。Groups the elements of a sequence according to a specified key selector function and compares the keys by using a specified comparer.

GroupBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>) GroupBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>) GroupBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>) GroupBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>)

分組依據指定的索引鍵選取器函式序列的項目。Groups the elements of a sequence according to a specified key selector function.

GroupJoin<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,IEnumerable<TInner>,TResult>>) GroupJoin<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,IEnumerable<TInner>,TResult>>) GroupJoin<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,IEnumerable<TInner>,TResult>>) GroupJoin<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,IEnumerable<TInner>,TResult>>)

根據索引鍵相等的兩個序列的項目相互關聯,並將結果分組。Correlates the elements of two sequences based on key equality and groups the results. 預設的相等比較子是用於比較索引鍵。The default equality comparer is used to compare keys.

GroupJoin<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,IEnumerable<TInner>,TResult>>, IEqualityComparer<TKey>) GroupJoin<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,IEnumerable<TInner>,TResult>>, IEqualityComparer<TKey>) GroupJoin<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,IEnumerable<TInner>,TResult>>, IEqualityComparer<TKey>) GroupJoin<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,IEnumerable<TInner>,TResult>>, IEqualityComparer<TKey>)

根據索引鍵相等的兩個序列的項目相互關聯,並將結果分組。Correlates the elements of two sequences based on key equality and groups the results. 指定IEqualityComparer<T>用來比較索引鍵。A specified IEqualityComparer<T> is used to compare keys.

Intersect<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Intersect<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Intersect<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Intersect<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

使用預設相等比較子來比較值,以便產生兩個序列的交集。Produces the set intersection of two sequences by using the default equality comparer to compare values.

Intersect<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Intersect<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Intersect<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Intersect<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>)

使用指定,以便產生兩個序列的集合交集IEqualityComparer<T>來比較值。Produces the set intersection of two sequences by using the specified IEqualityComparer<T> to compare values.

Join<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,TInner,TResult>>) Join<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,TInner,TResult>>) Join<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,TInner,TResult>>) Join<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,TInner,TResult>>)

根據相符索引鍵的兩個序列的項目相互關聯。Correlates the elements of two sequences based on matching keys. 預設的相等比較子是用於比較索引鍵。The default equality comparer is used to compare keys.

Join<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,TInner,TResult>>, IEqualityComparer<TKey>) Join<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,TInner,TResult>>, IEqualityComparer<TKey>) Join<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,TInner,TResult>>, IEqualityComparer<TKey>) Join<TOuter,TInner,TKey,TResult>(IQueryable<TOuter>, IEnumerable<TInner>, Expression<Func<TOuter,TKey>>, Expression<Func<TInner,TKey>>, Expression<Func<TOuter,TInner,TResult>>, IEqualityComparer<TKey>)

根據相符索引鍵的兩個序列的項目相互關聯。Correlates the elements of two sequences based on matching keys. 指定IEqualityComparer<T>用來比較索引鍵。A specified IEqualityComparer<T> is used to compare keys.

Last<TSource>(IQueryable<TSource>) Last<TSource>(IQueryable<TSource>) Last<TSource>(IQueryable<TSource>) Last<TSource>(IQueryable<TSource>)

傳回序列中的最後一個項目。Returns the last element in a sequence.

Last<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Last<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Last<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Last<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

傳回序列中符合指定之條件的最後一個元素。Returns the last element of a sequence that satisfies a specified condition.

LastOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) LastOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) LastOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) LastOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

傳回序列中符合條件的最後一個元素;如果找不到這類元素,則傳回預設值。Returns the last element of a sequence that satisfies a condition or a default value if no such element is found.

LastOrDefault<TSource>(IQueryable<TSource>) LastOrDefault<TSource>(IQueryable<TSource>) LastOrDefault<TSource>(IQueryable<TSource>) LastOrDefault<TSource>(IQueryable<TSource>)

傳回最後一個項目序列,或預設值,如果序列不包含任何項目。Returns the last element in a sequence, or a default value if the sequence contains no elements.

LongCount<TSource>(IQueryable<TSource>) LongCount<TSource>(IQueryable<TSource>) LongCount<TSource>(IQueryable<TSource>) LongCount<TSource>(IQueryable<TSource>)

傳回Int64代表序列中的項目總數。Returns an Int64 that represents the total number of elements in a sequence.

LongCount<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) LongCount<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) LongCount<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) LongCount<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

傳回Int64代表序列中符合條件的項目數目。Returns an Int64 that represents the number of elements in a sequence that satisfy a condition.

Max<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) Max<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) Max<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) Max<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>)

叫用投影函式的泛型的每個項目上IQueryable<T>並傳回最大的結果值。Invokes a projection function on each element of a generic IQueryable<T> and returns the maximum resulting value.

Max<TSource>(IQueryable<TSource>) Max<TSource>(IQueryable<TSource>) Max<TSource>(IQueryable<TSource>) Max<TSource>(IQueryable<TSource>)

傳回的最大值,在泛型IQueryable<T>Returns the maximum value in a generic IQueryable<T>.

Min<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) Min<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) Min<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) Min<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>)

叫用投影函式的泛型的每個項目上IQueryable<T>並傳回最小的結果值。Invokes a projection function on each element of a generic IQueryable<T> and returns the minimum resulting value.

Min<TSource>(IQueryable<TSource>) Min<TSource>(IQueryable<TSource>) Min<TSource>(IQueryable<TSource>) Min<TSource>(IQueryable<TSource>)

傳回泛型的最小值IQueryable<T>Returns the minimum value of a generic IQueryable<T>.

OfType<TResult>(IQueryable) OfType<TResult>(IQueryable) OfType<TResult>(IQueryable) OfType<TResult>(IQueryable)

篩選的項目IQueryable根據指定的型別。Filters the elements of an IQueryable based on a specified type.

OrderBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>) OrderBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>) OrderBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>) OrderBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>)

排序序列中使用指定的比較子,依遞增順序的項目。Sorts the elements of a sequence in ascending order by using a specified comparer.

OrderBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>) OrderBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>) OrderBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>) OrderBy<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>)

排序序列中遞增的順序,根據索引鍵的項目。Sorts the elements of a sequence in ascending order according to a key.

OrderByDescending<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>) OrderByDescending<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>) OrderByDescending<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>) OrderByDescending<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>)

排序序列中遞減的順序,根據索引鍵的項目。Sorts the elements of a sequence in descending order according to a key.

OrderByDescending<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>) OrderByDescending<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>) OrderByDescending<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>) OrderByDescending<TSource,TKey>(IQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>)

使用指定的比較子,依遞減順序排序序列中的項目。Sorts the elements of a sequence in descending order by using a specified comparer.

Prepend<TSource>(IQueryable<TSource>, TSource) Prepend<TSource>(IQueryable<TSource>, TSource) Prepend<TSource>(IQueryable<TSource>, TSource) Prepend<TSource>(IQueryable<TSource>, TSource)
Reverse<TSource>(IQueryable<TSource>) Reverse<TSource>(IQueryable<TSource>) Reverse<TSource>(IQueryable<TSource>) Reverse<TSource>(IQueryable<TSource>)

反轉序列中項目的順序。Inverts the order of the elements in a sequence.

Select<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,Int32,TResult>>) Select<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,Int32,TResult>>) Select<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,Int32,TResult>>) Select<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,Int32,TResult>>)

投射成新的表單序列的每個項目,透過加入項目的索引。Projects each element of a sequence into a new form by incorporating the element's index.

Select<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) Select<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) Select<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>) Select<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,TResult>>)

將序列的每個元素規劃成一個新的表單。Projects each element of a sequence into a new form.

SelectMany<TSource,TCollection,TResult>(IQueryable<TSource>, Expression<Func<TSource,Int32,IEnumerable<TCollection>>>, Expression<Func<TSource,TCollection,TResult>>) SelectMany<TSource,TCollection,TResult>(IQueryable<TSource>, Expression<Func<TSource,Int32,IEnumerable<TCollection>>>, Expression<Func<TSource,TCollection,TResult>>) SelectMany<TSource,TCollection,TResult>(IQueryable<TSource>, Expression<Func<TSource,Int32,IEnumerable<TCollection>>>, Expression<Func<TSource,TCollection,TResult>>) SelectMany<TSource,TCollection,TResult>(IQueryable<TSource>, Expression<Func<TSource,Int32,IEnumerable<TCollection>>>, Expression<Func<TSource,TCollection,TResult>>)

每個序列的項目至IEnumerable<T>,其中包含產生它的來源項目的索引。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.

SelectMany<TSource,TCollection,TResult>(IQueryable<TSource>, Expression<Func<TSource,IEnumerable<TCollection>>>, Expression<Func<TSource,TCollection,TResult>>) SelectMany<TSource,TCollection,TResult>(IQueryable<TSource>, Expression<Func<TSource,IEnumerable<TCollection>>>, Expression<Func<TSource,TCollection,TResult>>) SelectMany<TSource,TCollection,TResult>(IQueryable<TSource>, Expression<Func<TSource,IEnumerable<TCollection>>>, Expression<Func<TSource,TCollection,TResult>>) SelectMany<TSource,TCollection,TResult>(IQueryable<TSource>, Expression<Func<TSource,IEnumerable<TCollection>>>, Expression<Func<TSource,TCollection,TResult>>)

每個序列的項目至IEnumerable<T>其中叫用結果選取器函式,每個項目。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.

SelectMany<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,Int32,IEnumerable<TResult>>>) SelectMany<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,Int32,IEnumerable<TResult>>>) SelectMany<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,Int32,IEnumerable<TResult>>>) SelectMany<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,Int32,IEnumerable<TResult>>>)

每個序列的項目至IEnumerable<T>和結合成單一序列產生的序列。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.

SelectMany<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,IEnumerable<TResult>>>) SelectMany<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,IEnumerable<TResult>>>) SelectMany<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,IEnumerable<TResult>>>) SelectMany<TSource,TResult>(IQueryable<TSource>, Expression<Func<TSource,IEnumerable<TResult>>>)

每個序列的項目至IEnumerable<T>和結合成單一序列產生的序列。Projects each element of a sequence to an IEnumerable<T> and combines the resulting sequences into one sequence.

SequenceEqual<TSource>(IQueryable<TSource>, IEnumerable<TSource>) SequenceEqual<TSource>(IQueryable<TSource>, IEnumerable<TSource>) SequenceEqual<TSource>(IQueryable<TSource>, IEnumerable<TSource>) SequenceEqual<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

判斷兩個序列是否相等,使用預設相等比較子來比較項目。Determines whether two sequences are equal by using the default equality comparer to compare elements.

SequenceEqual<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) SequenceEqual<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) SequenceEqual<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) SequenceEqual<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>)

判斷兩個序列是否相等,使用指定的IEqualityComparer<T>來比較項目。Determines whether two sequences are equal by using a specified IEqualityComparer<T> to compare elements.

Single<TSource>(IQueryable<TSource>) Single<TSource>(IQueryable<TSource>) Single<TSource>(IQueryable<TSource>) Single<TSource>(IQueryable<TSource>)

傳回序列的唯一一個元素,如果序列中不是正好一個元素,則擲回例外狀況。Returns the only element of a sequence, and throws an exception if there is not exactly one element in the sequence.

Single<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Single<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Single<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Single<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

傳回序列中符合指定之條件的唯一一個元素,如果有一個以上這類元素,則擲回例外狀況。Returns the only element of a sequence that satisfies a specified condition, and throws an exception if more than one such element exists.

SingleOrDefault<TSource>(IQueryable<TSource>) SingleOrDefault<TSource>(IQueryable<TSource>) SingleOrDefault<TSource>(IQueryable<TSource>) SingleOrDefault<TSource>(IQueryable<TSource>)

如果序列是空的則會傳回序列,則為預設值的唯一項目如果序列中有多個項目,則這個方法會擲回例外狀況。Returns the only element of a sequence, or a default value if the sequence is empty; this method throws an exception if there is more than one element in the sequence.

SingleOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) SingleOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) SingleOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) SingleOrDefault<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

傳回序列中符合指定之條件的唯一一個元素,如果沒有這類元素,則為預設值,如果有一個以上的元素符合條件,這個方法就會擲回例外狀況。Returns the only element of a sequence that satisfies a specified condition or a default value if no such element exists; this method throws an exception if more than one element satisfies the condition.

Skip<TSource>(IQueryable<TSource>, Int32) Skip<TSource>(IQueryable<TSource>, Int32) Skip<TSource>(IQueryable<TSource>, Int32) Skip<TSource>(IQueryable<TSource>, Int32)

略過指定的數目的序列中的項目,然後傳回其餘項目。Bypasses a specified number of elements in a sequence and then returns the remaining elements.

SkipLast<TSource>(IQueryable<TSource>, Int32) SkipLast<TSource>(IQueryable<TSource>, Int32) SkipLast<TSource>(IQueryable<TSource>, Int32) SkipLast<TSource>(IQueryable<TSource>, Int32)
SkipWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) SkipWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) SkipWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) SkipWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

只要指定的條件為 true,然後傳回其餘項目,請略過序列中的項目。Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements.

SkipWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32,Boolean>>) SkipWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32,Boolean>>) SkipWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32,Boolean>>) SkipWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32,Boolean>>)

只要指定的條件為 true,然後傳回其餘項目,請略過序列中的項目。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.

Sum(IQueryable<Single>) Sum(IQueryable<Single>) Sum(IQueryable<Single>) Sum(IQueryable<Single>)

計算序列的總和Single值。Computes the sum of a sequence of Single values.

Sum(IQueryable<Nullable<Single>>) Sum(IQueryable<Nullable<Single>>) Sum(IQueryable<Nullable<Single>>) Sum(IQueryable<Nullable<Single>>)

計算可為 null 的序列的總和Single值。Computes the sum of a sequence of nullable Single values.

Sum(IQueryable<Nullable<Int64>>) Sum(IQueryable<Nullable<Int64>>) Sum(IQueryable<Nullable<Int64>>) Sum(IQueryable<Nullable<Int64>>)

計算可為 null 的序列的總和Int64值。Computes the sum of a sequence of nullable Int64 values.

Sum(IQueryable<Nullable<Int32>>) Sum(IQueryable<Nullable<Int32>>) Sum(IQueryable<Nullable<Int32>>) Sum(IQueryable<Nullable<Int32>>)

計算可為 null 的序列的總和Int32值。Computes the sum of a sequence of nullable Int32 values.

Sum(IQueryable<Nullable<Double>>) Sum(IQueryable<Nullable<Double>>) Sum(IQueryable<Nullable<Double>>) Sum(IQueryable<Nullable<Double>>)

計算可為 null 的序列的總和Double值。Computes the sum of a sequence of nullable Double values.

Sum(IQueryable<Int32>) Sum(IQueryable<Int32>) Sum(IQueryable<Int32>) Sum(IQueryable<Int32>)

計算序列的總和Int32值。Computes the sum of a sequence of Int32 values.

Sum(IQueryable<Int64>) Sum(IQueryable<Int64>) Sum(IQueryable<Int64>) Sum(IQueryable<Int64>)

計算序列的總和Int64值。Computes the sum of a sequence of Int64 values.

Sum(IQueryable<Nullable<Decimal>>) Sum(IQueryable<Nullable<Decimal>>) Sum(IQueryable<Nullable<Decimal>>) Sum(IQueryable<Nullable<Decimal>>)

計算可為 null 的序列的總和Decimal值。Computes the sum of a sequence of nullable Decimal values.

Sum(IQueryable<Double>) Sum(IQueryable<Double>) Sum(IQueryable<Double>) Sum(IQueryable<Double>)

計算序列的總和Double值。Computes the sum of a sequence of Double values.

Sum(IQueryable<Decimal>) Sum(IQueryable<Decimal>) Sum(IQueryable<Decimal>) Sum(IQueryable<Decimal>)

計算序列的總和Decimal值。Computes the sum of a sequence of Decimal values.

Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>)

計算可為 null 的序列的總和Single叫用投影函式的輸入序列的每個項目所取得的值。Computes the sum of the sequence of nullable Single values that is obtained by invoking a projection function on each element of the input sequence.

Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>)

計算可為 null 的序列的總和Int64叫用投影函式的輸入序列的每個項目所取得的值。Computes the sum of the sequence of nullable Int64 values that is obtained by invoking a projection function on each element of the input sequence.

Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>)

計算可為 null 的序列的總和Int32叫用投影函式的輸入序列的每個項目所取得的值。Computes the sum of the sequence of nullable Int32 values that is obtained by invoking a projection function on each element of the input sequence.

Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>)

計算可為 null 的序列的總和Double叫用投影函式的輸入序列的每個項目所取得的值。Computes the sum of the sequence of nullable Double values that is obtained by invoking a projection function on each element of the input sequence.

Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>)

計算序列的總和Single叫用投影函式的輸入序列的每個項目所取得的值。Computes the sum of the sequence of Single values that is obtained by invoking a projection function on each element of the input sequence.

Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>)

計算序列的總和Int64叫用投影函式的輸入序列的每個項目所取得的值。Computes the sum of the sequence of Int64 values that is obtained by invoking a projection function on each element of the input sequence.

Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>)

計算序列的總和Int32叫用投影函式的輸入序列的每個項目所取得的值。Computes the sum of the sequence of Int32 values that is obtained by invoking a projection function on each element of the input sequence.

Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)

計算序列的總和Double叫用投影函式的輸入序列的每個項目所取得的值。Computes the sum of the sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.

Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>)

計算序列的總和Decimal叫用投影函式的輸入序列的每個項目所取得的值。Computes the sum of the sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.

Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>) Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>)

計算可為 null 的序列的總和Decimal叫用投影函式的輸入序列的每個項目所取得的值。Computes the sum of the sequence of nullable Decimal values that is obtained by invoking a projection function on each element of the input sequence.

Take<TSource>(IQueryable<TSource>, Int32) Take<TSource>(IQueryable<TSource>, Int32) Take<TSource>(IQueryable<TSource>, Int32) Take<TSource>(IQueryable<TSource>, Int32)

從序列開頭傳回指定的數目的連續項目。Returns a specified number of contiguous elements from the start of a sequence.

TakeLast<TSource>(IQueryable<TSource>, Int32) TakeLast<TSource>(IQueryable<TSource>, Int32) TakeLast<TSource>(IQueryable<TSource>, Int32) TakeLast<TSource>(IQueryable<TSource>, Int32)
TakeWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) TakeWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) TakeWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) TakeWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

傳回序列中的項目,只要指定的條件為 true。Returns elements from a sequence as long as a specified condition is true.

TakeWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32,Boolean>>) TakeWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32,Boolean>>) TakeWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32,Boolean>>) TakeWhile<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32,Boolean>>)

傳回序列中的項目,只要指定的條件為 true。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.

ThenBy<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>) ThenBy<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>) ThenBy<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>) ThenBy<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>)

執行中使用指定的比較子,依遞增順序的序列中項目的後續排序作業。Performs a subsequent ordering of the elements in a sequence in ascending order by using a specified comparer.

ThenBy<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>) ThenBy<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>) ThenBy<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>) ThenBy<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>)

執行以遞增順序依據索引鍵序列中項目的後續排序作業。Performs a subsequent ordering of the elements in a sequence in ascending order according to a key.

ThenByDescending<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>) ThenByDescending<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>) ThenByDescending<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>) ThenByDescending<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>)

依據索引鍵,會執行以遞減順序,序列中項目的後續排序作業。Performs a subsequent ordering of the elements in a sequence in descending order, according to a key.

ThenByDescending<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>) ThenByDescending<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>) ThenByDescending<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>) ThenByDescending<TSource,TKey>(IOrderedQueryable<TSource>, Expression<Func<TSource,TKey>>, IComparer<TKey>)

執行以遞減順序,使用指定的比較子序列中項目的後續排序作業。Performs a subsequent ordering of the elements in a sequence in descending order by using a specified comparer.

Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

使用預設相等比較子,以便產生兩個序列的聯集。Produces the set union of two sequences by using the default equality comparer.

Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>) Union<TSource>(IQueryable<TSource>, IEnumerable<TSource>, IEqualityComparer<TSource>)

使用指定的產生兩個序列的聯集IEqualityComparer<T>Produces the set union of two sequences by using a specified IEqualityComparer<T>.

Where<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Where<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Where<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>) Where<TSource>(IQueryable<TSource>, Expression<Func<TSource,Boolean>>)

根據述詞來篩選值序列。Filters a sequence of values based on a predicate.

Where<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32,Boolean>>) Where<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32,Boolean>>) Where<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32,Boolean>>) Where<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32,Boolean>>)

根據述詞來篩選值序列。Filters a sequence of values based on a predicate. 述詞函式的邏輯中使用各項目的索引。Each element's index is used in the logic of the predicate function.

Zip<TFirst,TSecond,TResult>(IQueryable<TFirst>, IEnumerable<TSecond>, Expression<Func<TFirst,TSecond,TResult>>) Zip<TFirst,TSecond,TResult>(IQueryable<TFirst>, IEnumerable<TSecond>, Expression<Func<TFirst,TSecond,TResult>>) Zip<TFirst,TSecond,TResult>(IQueryable<TFirst>, IEnumerable<TSecond>, Expression<Func<TFirst,TSecond,TResult>>) Zip<TFirst,TSecond,TResult>(IQueryable<TFirst>, IEnumerable<TSecond>, Expression<Func<TFirst,TSecond,TResult>>)

使用指定的述詞函式來合併兩個序列。Merges two sequences by using the specified predicate function.

Zip<TFirst,TSecond>(IQueryable<TFirst>, IEnumerable<TSecond>) Zip<TFirst,TSecond>(IQueryable<TFirst>, IEnumerable<TSecond>) Zip<TFirst,TSecond>(IQueryable<TFirst>, IEnumerable<TSecond>) Zip<TFirst,TSecond>(IQueryable<TFirst>, IEnumerable<TSecond>)

適用於

另請參閱