Queryable.Sum Queryable.Sum Queryable.Sum Queryable.Sum Method

定義

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

多載

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.

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

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

public:
[System::Runtime::CompilerServices::Extension]
 static float Sum(System::Linq::IQueryable<float> ^ source);
public static float Sum (this System.Linq.IQueryable<float> source);
static member Sum : System.Linq.IQueryable<single> -> single
<Extension()>
Public Function Sum (source As IQueryable(Of Single)) As Single

參數

source
IQueryable<Single>

要計算總和的 Single 值序列。A sequence of Single values to calculate the sum of.

傳回

序列中值的總合。The sum of the values in the sequence.

例外狀況

範例

下列程式碼範例示範如何使用Sum(IQueryable<Single>)來加總序列的值。The following code example demonstrates how to use Sum(IQueryable<Single>) to sum the values of a sequence.

List<float> numbers = new List<float> { 43.68F, 1.25F, 583.7F, 6.5F };

float sum = numbers.AsQueryable().Sum();

Console.WriteLine("The sum of the numbers is {0}.", sum);

/*
    This code produces the following output:

    The sum of the numbers is 635.13.
*/

Dim numbers As New List(Of Single)(New Single() {43.68F, 1.25F, 583.7F, 6.5F})

Dim sum As Single = numbers.AsQueryable().Sum()

MsgBox("The sum of the numbers is " & sum)

' This code produces the following output:

' The sum of the numbers is 635.13.

備註

方法會產生, 其代表以Sum(IQueryable<Single>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum(IQueryable<Single>)The Sum(IQueryable<Single>) method generates a MethodCallExpression that represents calling Sum(IQueryable<Single>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum(IQueryable<Single>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum(IQueryable<Single>) depends on the implementation of the type of the source parameter. 預期的行為是它會傳回中source值的總和。The expected behavior is that it returns the sum of the values in source.

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.

public:
[System::Runtime::CompilerServices::Extension]
 static Nullable<float> Sum(System::Linq::IQueryable<Nullable<float>> ^ source);
public static Nullable<float> Sum (this System.Linq.IQueryable<Nullable<float>> source);
static member Sum : System.Linq.IQueryable<Nullable<single>> -> Nullable<single>
<Extension()>
Public Function Sum (source As IQueryable(Of Nullable(Of Single))) As Nullable(Of Single)

參數

source
IQueryable<Nullable<Single>>

要計算總和之可為 Null 的 Single 值序列。A sequence of nullable Single values to calculate the sum of.

傳回

序列中值的總合。The sum of the values in the sequence.

例外狀況

範例

下列程式碼範例示範如何使用Sum(IQueryable<Nullable<Single>>)來加總序列的值。The following code example demonstrates how to use Sum(IQueryable<Nullable<Single>>) to sum the values of a sequence.

float?[] points = { null, 0, 92.83F, null, 100.0F, 37.46F, 81.1F };

float? sum = points.AsQueryable().Sum();

Console.WriteLine("Total points earned: {0}", sum);

/*
    This code produces the following output:

    Total points earned: 311.39
*/

Dim points As Nullable(Of Single)() = {Nothing, 0, 92.83F, Nothing, 100.0F, 37.46F, 81.1F}

Dim sum As Nullable(Of Single) = points.AsQueryable().Sum()

MsgBox("Total points earned: " & sum)

'This code produces the following output:

'Total points earned: 311.39

備註

方法會產生, 其代表以Sum(IQueryable<Nullable<Single>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum(IQueryable<Nullable<Single>>)The Sum(IQueryable<Nullable<Single>>) method generates a MethodCallExpression that represents calling Sum(IQueryable<Nullable<Single>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum(IQueryable<Nullable<Single>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum(IQueryable<Nullable<Single>>) depends on the implementation of the type of the source parameter. 預期的行為是它會傳回中source值的總和。The expected behavior is that it returns the sum of the values in source.

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.

public:
[System::Runtime::CompilerServices::Extension]
 static Nullable<long> Sum(System::Linq::IQueryable<Nullable<long>> ^ source);
public static Nullable<long> Sum (this System.Linq.IQueryable<Nullable<long>> source);
static member Sum : System.Linq.IQueryable<Nullable<int64>> -> Nullable<int64>
<Extension()>
Public Function Sum (source As IQueryable(Of Nullable(Of Long))) As Nullable(Of Long)

參數

source
IQueryable<Nullable<Int64>>

要計算總和之可為 Null 的 Int64 值序列。A sequence of nullable Int64 values to calculate the sum of.

傳回

序列中值的總合。The sum of the values in the sequence.

例外狀況

範例

下列程式碼範例示範如何使用Sum(IQueryable<Nullable<Single>>)來加總序列的值。The following code example demonstrates how to use Sum(IQueryable<Nullable<Single>>) to sum the values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要擴充範例以符合本主題內容,請以具有適當數值類型的項目取代來源序列的項目。To extend the example to this topic, substitute the elements of the source sequence with elements of the appropriate numerical type.

float?[] points = { null, 0, 92.83F, null, 100.0F, 37.46F, 81.1F };

float? sum = points.AsQueryable().Sum();

Console.WriteLine("Total points earned: {0}", sum);

/*
    This code produces the following output:

    Total points earned: 311.39
*/

Dim points As Nullable(Of Single)() = {Nothing, 0, 92.83F, Nothing, 100.0F, 37.46F, 81.1F}

Dim sum As Nullable(Of Single) = points.AsQueryable().Sum()

MsgBox("Total points earned: " & sum)

'This code produces the following output:

'Total points earned: 311.39

備註

方法會產生, 其代表以Sum(IQueryable<Nullable<Int64>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum(IQueryable<Nullable<Int64>>)The Sum(IQueryable<Nullable<Int64>>) method generates a MethodCallExpression that represents calling Sum(IQueryable<Nullable<Int64>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum(IQueryable<Nullable<Int64>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum(IQueryable<Nullable<Int64>>) depends on the implementation of the type of the source parameter. 預期的行為是它會傳回中source值的總和。The expected behavior is that it returns the sum of the values in source.

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.

public:
[System::Runtime::CompilerServices::Extension]
 static Nullable<int> Sum(System::Linq::IQueryable<Nullable<int>> ^ source);
public static Nullable<int> Sum (this System.Linq.IQueryable<Nullable<int>> source);
static member Sum : System.Linq.IQueryable<Nullable<int>> -> Nullable<int>
<Extension()>
Public Function Sum (source As IQueryable(Of Nullable(Of Integer))) As Nullable(Of Integer)

參數

source
IQueryable<Nullable<Int32>>

要計算總和之可為 Null 的 Int32 值序列。A sequence of nullable Int32 values to calculate the sum of.

傳回

序列中值的總合。The sum of the values in the sequence.

例外狀況

範例

下列程式碼範例示範如何使用Sum(IQueryable<Nullable<Single>>)來加總序列的值。The following code example demonstrates how to use Sum(IQueryable<Nullable<Single>>) to sum the values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要擴充範例以符合本主題內容,請以具有適當數值類型的項目取代來源序列的項目。To extend the example to this topic, substitute the elements of the source sequence with elements of the appropriate numerical type.

float?[] points = { null, 0, 92.83F, null, 100.0F, 37.46F, 81.1F };

float? sum = points.AsQueryable().Sum();

Console.WriteLine("Total points earned: {0}", sum);

/*
    This code produces the following output:

    Total points earned: 311.39
*/

Dim points As Nullable(Of Single)() = {Nothing, 0, 92.83F, Nothing, 100.0F, 37.46F, 81.1F}

Dim sum As Nullable(Of Single) = points.AsQueryable().Sum()

MsgBox("Total points earned: " & sum)

'This code produces the following output:

'Total points earned: 311.39

備註

方法會產生, 其代表以Sum(IQueryable<Nullable<Int32>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum(IQueryable<Nullable<Int32>>)The Sum(IQueryable<Nullable<Int32>>) method generates a MethodCallExpression that represents calling Sum(IQueryable<Nullable<Int32>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum(IQueryable<Nullable<Int32>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum(IQueryable<Nullable<Int32>>) depends on the implementation of the type of the source parameter. 預期的行為是它會傳回中source值的總和。The expected behavior is that it returns the sum of the values in source.

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.

public:
[System::Runtime::CompilerServices::Extension]
 static Nullable<double> Sum(System::Linq::IQueryable<Nullable<double>> ^ source);
public static Nullable<double> Sum (this System.Linq.IQueryable<Nullable<double>> source);
static member Sum : System.Linq.IQueryable<Nullable<double>> -> Nullable<double>
<Extension()>
Public Function Sum (source As IQueryable(Of Nullable(Of Double))) As Nullable(Of Double)

參數

source
IQueryable<Nullable<Double>>

要計算總和之可為 Null 的 Double 值序列。A sequence of nullable Double values to calculate the sum of.

傳回

序列中值的總合。The sum of the values in the sequence.

例外狀況

範例

下列程式碼範例示範如何使用Sum(IQueryable<Nullable<Single>>)來加總序列的值。The following code example demonstrates how to use Sum(IQueryable<Nullable<Single>>) to sum the values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要擴充範例以符合本主題內容,請以具有適當數值類型的項目取代來源序列的項目。To extend the example to this topic, substitute the elements of the source sequence with elements of the appropriate numerical type.

float?[] points = { null, 0, 92.83F, null, 100.0F, 37.46F, 81.1F };

float? sum = points.AsQueryable().Sum();

Console.WriteLine("Total points earned: {0}", sum);

/*
    This code produces the following output:

    Total points earned: 311.39
*/

Dim points As Nullable(Of Single)() = {Nothing, 0, 92.83F, Nothing, 100.0F, 37.46F, 81.1F}

Dim sum As Nullable(Of Single) = points.AsQueryable().Sum()

MsgBox("Total points earned: " & sum)

'This code produces the following output:

'Total points earned: 311.39

備註

方法會產生, 其代表以Sum(IQueryable<Nullable<Double>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum(IQueryable<Nullable<Double>>)The Sum(IQueryable<Nullable<Double>>) method generates a MethodCallExpression that represents calling Sum(IQueryable<Nullable<Double>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum(IQueryable<Nullable<Double>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum(IQueryable<Nullable<Double>>) depends on the implementation of the type of the source parameter. 預期的行為是它會傳回中source值的總和。The expected behavior is that it returns the sum of the values in source.

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

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

public:
[System::Runtime::CompilerServices::Extension]
 static int Sum(System::Linq::IQueryable<int> ^ source);
public static int Sum (this System.Linq.IQueryable<int> source);
static member Sum : System.Linq.IQueryable<int> -> int
<Extension()>
Public Function Sum (source As IQueryable(Of Integer)) As Integer

參數

source
IQueryable<Int32>

要計算總和的 Int32 值序列。A sequence of Int32 values to calculate the sum of.

傳回

序列中值的總合。The sum of the values in the sequence.

例外狀況

範例

下列程式碼範例示範如何使用Sum(IQueryable<Single>)來加總序列的值。The following code example demonstrates how to use Sum(IQueryable<Single>) to sum the values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要擴充範例以符合本主題內容,請以具有適當數值類型的項目取代來源序列的項目。To extend the example to this topic, substitute the elements of the source sequence with elements of the appropriate numerical type.

List<float> numbers = new List<float> { 43.68F, 1.25F, 583.7F, 6.5F };

float sum = numbers.AsQueryable().Sum();

Console.WriteLine("The sum of the numbers is {0}.", sum);

/*
    This code produces the following output:

    The sum of the numbers is 635.13.
*/

Dim numbers As New List(Of Single)(New Single() {43.68F, 1.25F, 583.7F, 6.5F})

Dim sum As Single = numbers.AsQueryable().Sum()

MsgBox("The sum of the numbers is " & sum)

' This code produces the following output:

' The sum of the numbers is 635.13.

備註

方法會產生, 其代表以Sum(IQueryable<Int32>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum(IQueryable<Int32>)The Sum(IQueryable<Int32>) method generates a MethodCallExpression that represents calling Sum(IQueryable<Int32>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum(IQueryable<Int32>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum(IQueryable<Int32>) depends on the implementation of the type of the source parameter. 預期的行為是它會傳回中source值的總和。The expected behavior is that it returns the sum of the values in source.

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

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

public:
[System::Runtime::CompilerServices::Extension]
 static long Sum(System::Linq::IQueryable<long> ^ source);
public static long Sum (this System.Linq.IQueryable<long> source);
static member Sum : System.Linq.IQueryable<int64> -> int64
<Extension()>
Public Function Sum (source As IQueryable(Of Long)) As Long

參數

source
IQueryable<Int64>

要計算總和的 Int64 值序列。A sequence of Int64 values to calculate the sum of.

傳回

序列中值的總合。The sum of the values in the sequence.

例外狀況

範例

下列程式碼範例示範如何使用Sum(IQueryable<Single>)來加總序列的值。The following code example demonstrates how to use Sum(IQueryable<Single>) to sum the values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要擴充範例以符合本主題內容,請以具有適當數值類型的項目取代來源序列的項目。To extend the example to this topic, substitute the elements of the source sequence with elements of the appropriate numerical type.

List<float> numbers = new List<float> { 43.68F, 1.25F, 583.7F, 6.5F };

float sum = numbers.AsQueryable().Sum();

Console.WriteLine("The sum of the numbers is {0}.", sum);

/*
    This code produces the following output:

    The sum of the numbers is 635.13.
*/

Dim numbers As New List(Of Single)(New Single() {43.68F, 1.25F, 583.7F, 6.5F})

Dim sum As Single = numbers.AsQueryable().Sum()

MsgBox("The sum of the numbers is " & sum)

' This code produces the following output:

' The sum of the numbers is 635.13.

備註

方法會產生, 其代表以Sum(IQueryable<Int64>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum(IQueryable<Int64>)The Sum(IQueryable<Int64>) method generates a MethodCallExpression that represents calling Sum(IQueryable<Int64>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum(IQueryable<Int64>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum(IQueryable<Int64>) depends on the implementation of the type of the source parameter. 預期的行為是它會傳回中source值的總和。The expected behavior is that it returns the sum of the values in source.

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.

public:
[System::Runtime::CompilerServices::Extension]
 static Nullable<System::Decimal> Sum(System::Linq::IQueryable<Nullable<System::Decimal>> ^ source);
public static Nullable<decimal> Sum (this System.Linq.IQueryable<Nullable<decimal>> source);
static member Sum : System.Linq.IQueryable<Nullable<decimal>> -> Nullable<decimal>
<Extension()>
Public Function Sum (source As IQueryable(Of Nullable(Of Decimal))) As Nullable(Of Decimal)

參數

source
IQueryable<Nullable<Decimal>>

要計算總和之可為 Null 的 Decimal 值序列。A sequence of nullable Decimal values to calculate the sum of.

傳回

序列中值的總合。The sum of the values in the sequence.

例外狀況

範例

下列程式碼範例示範如何使用Sum(IQueryable<Nullable<Single>>)來加總序列的值。The following code example demonstrates how to use Sum(IQueryable<Nullable<Single>>) to sum the values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要擴充範例以符合本主題內容,請以具有適當數值類型的項目取代來源序列的項目。To extend the example to this topic, substitute the elements of the source sequence with elements of the appropriate numerical type.

float?[] points = { null, 0, 92.83F, null, 100.0F, 37.46F, 81.1F };

float? sum = points.AsQueryable().Sum();

Console.WriteLine("Total points earned: {0}", sum);

/*
    This code produces the following output:

    Total points earned: 311.39
*/

Dim points As Nullable(Of Single)() = {Nothing, 0, 92.83F, Nothing, 100.0F, 37.46F, 81.1F}

Dim sum As Nullable(Of Single) = points.AsQueryable().Sum()

MsgBox("Total points earned: " & sum)

'This code produces the following output:

'Total points earned: 311.39

備註

方法會產生, 其代表以Sum(IQueryable<Nullable<Decimal>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum(IQueryable<Nullable<Decimal>>)The Sum(IQueryable<Nullable<Decimal>>) method generates a MethodCallExpression that represents calling Sum(IQueryable<Nullable<Decimal>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum(IQueryable<Nullable<Decimal>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum(IQueryable<Nullable<Decimal>>) depends on the implementation of the type of the source parameter. 預期的行為是它會傳回中source值的總和。The expected behavior is that it returns the sum of the values in source.

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

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

public:
[System::Runtime::CompilerServices::Extension]
 static double Sum(System::Linq::IQueryable<double> ^ source);
public static double Sum (this System.Linq.IQueryable<double> source);
static member Sum : System.Linq.IQueryable<double> -> double
<Extension()>
Public Function Sum (source As IQueryable(Of Double)) As Double

參數

source
IQueryable<Double>

要計算總和的 Double 值序列。A sequence of Double values to calculate the sum of.

傳回

序列中值的總合。The sum of the values in the sequence.

例外狀況

範例

下列程式碼範例示範如何使用Sum(IQueryable<Single>)來加總序列的值。The following code example demonstrates how to use Sum(IQueryable<Single>) to sum the values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要擴充範例以符合本主題內容,請以具有適當數值類型的項目取代來源序列的項目。To extend the example to this topic, substitute the elements of the source sequence with elements of the appropriate numerical type.

List<float> numbers = new List<float> { 43.68F, 1.25F, 583.7F, 6.5F };

float sum = numbers.AsQueryable().Sum();

Console.WriteLine("The sum of the numbers is {0}.", sum);

/*
    This code produces the following output:

    The sum of the numbers is 635.13.
*/

Dim numbers As New List(Of Single)(New Single() {43.68F, 1.25F, 583.7F, 6.5F})

Dim sum As Single = numbers.AsQueryable().Sum()

MsgBox("The sum of the numbers is " & sum)

' This code produces the following output:

' The sum of the numbers is 635.13.

備註

方法會產生, 其代表以Sum(IQueryable<Double>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum(IQueryable<Double>)The Sum(IQueryable<Double>) method generates a MethodCallExpression that represents calling Sum(IQueryable<Double>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum(IQueryable<Double>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum(IQueryable<Double>) depends on the implementation of the type of the source parameter. 預期的行為是它會傳回中source值的總和。The expected behavior is that it returns the sum of the values in source.

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

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

public:
[System::Runtime::CompilerServices::Extension]
 static System::Decimal Sum(System::Linq::IQueryable<System::Decimal> ^ source);
public static decimal Sum (this System.Linq.IQueryable<decimal> source);
static member Sum : System.Linq.IQueryable<decimal> -> decimal
<Extension()>
Public Function Sum (source As IQueryable(Of Decimal)) As Decimal

參數

source
IQueryable<Decimal>

要計算總和的 Decimal 值序列。A sequence of Decimal values to calculate the sum of.

傳回

序列中值的總合。The sum of the values in the sequence.

例外狀況

範例

下列程式碼範例示範如何使用Sum(IQueryable<Single>)來加總序列的值。The following code example demonstrates how to use Sum(IQueryable<Single>) to sum the values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要擴充範例以符合本主題內容,請以具有適當數值類型的項目取代來源序列的項目。To extend the example to this topic, substitute the elements of the source sequence with elements of the appropriate numerical type.

List<float> numbers = new List<float> { 43.68F, 1.25F, 583.7F, 6.5F };

float sum = numbers.AsQueryable().Sum();

Console.WriteLine("The sum of the numbers is {0}.", sum);

/*
    This code produces the following output:

    The sum of the numbers is 635.13.
*/

Dim numbers As New List(Of Single)(New Single() {43.68F, 1.25F, 583.7F, 6.5F})

Dim sum As Single = numbers.AsQueryable().Sum()

MsgBox("The sum of the numbers is " & sum)

' This code produces the following output:

' The sum of the numbers is 635.13.

備註

方法會產生, 其代表以Sum(IQueryable<Decimal>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum(IQueryable<Decimal>)The Sum(IQueryable<Decimal>) method generates a MethodCallExpression that represents calling Sum(IQueryable<Decimal>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum(IQueryable<Decimal>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum(IQueryable<Decimal>) depends on the implementation of the type of the source parameter. 預期的行為是它會傳回中source值的總和。The expected behavior is that it returns the sum of the values in source.

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.

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static Nullable<float> Sum(System::Linq::IQueryable<TSource> ^ source, System::Linq::Expressions::Expression<Func<TSource, Nullable<float>> ^> ^ selector);
public static Nullable<float> Sum<TSource> (this System.Linq.IQueryable<TSource> source, System.Linq.Expressions.Expression<Func<TSource,Nullable<float>>> selector);
static member Sum : System.Linq.IQueryable<'Source> * System.Linq.Expressions.Expression<Func<'Source, Nullable<single>>> -> Nullable<single>
<Extension()>
Public Function Sum(Of TSource) (source As IQueryable(Of TSource), selector As Expression(Of Func(Of TSource, Nullable(Of Single)))) As Nullable(Of Single)

類型參數

TSource

source 項目的類型。The type of the elements of source.

參數

source
IQueryable<TSource>

型別 TSource 的值序列。A sequence of values of type TSource.

selector
Expression<Func<TSource,Nullable<Single>>>

要套用到每個項目的投影函式。A projection function to apply to each element.

傳回

預計值的總合。The sum of the projected values.

例外狀況

sourceselectornullsource or selector is null.

範例

下列程式碼範例示範如何使用Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)來加總序列的預測值。The following code example demonstrates how to use Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) to sum the projected values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要將此範例延伸到本主題中使用,請變更 selector 函式的主體。To extend the example to this topic, change the body of the selector function.

class Package
{
    public string Company { get; set; }
    public double Weight { get; set; }
}

public static void SumEx3()
{
    List<Package> packages =
        new List<Package> 
            { new Package { Company = "Coho Vineyard", Weight = 25.2 },
              new Package { Company = "Lucerne Publishing", Weight = 18.7 },
              new Package { Company = "Wingtip Toys", Weight = 6.0 },
              new Package { Company = "Adventure Works", Weight = 33.8 } };

    // Calculate the sum of all package weights.
    double totalWeight = packages.AsQueryable().Sum(pkg => pkg.Weight);

    Console.WriteLine("The total weight of the packages is: {0}", totalWeight);
}

/*
    This code produces the following output:

    The total weight of the packages is: 83.7
*/

Structure Package
    Public Company As String
    Public Weight As Double
End Structure

Shared Sub SumEx3()
    Dim packages As New List(Of Package)(New Package() { _
            New Package With {.Company = "Coho Vineyard", .Weight = 25.2}, _
              New Package With {.Company = "Lucerne Publishing", .Weight = 18.7}, _
              New Package With {.Company = "Wingtip Toys", .Weight = 6.0}, _
              New Package With {.Company = "Adventure Works", .Weight = 33.8}})

    ' Calculate the sum of all package weights.
    Dim totalWeight As Double = packages.AsQueryable().Sum(Function(pkg) pkg.Weight)

    MsgBox("The total weight of the packages is: " & totalWeight)
End Sub

'This code produces the following output:

'The total weight of the packages is: 83.7

備註

這個方法至少有一個類型Expression<TDelegate>的參數, 其類型引數是其中一個Func<T,TResult>類型。This method has at least one parameter of type Expression<TDelegate> whose type argument is one of the Func<T,TResult> types. 針對這些參數, 您可以傳入 lambda 運算式, 它會編譯成Expression<TDelegate>For these parameters, you can pass in a lambda expression and it will be compiled to an Expression<TDelegate>.

方法會產生, 其代表以Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>)The Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>) method generates a MethodCallExpression that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Single>>>) depends on the implementation of the type of the source parameter. 預期的行為是它selector會在的source每個專案上叫用, 並傳回產生之值的總和。The expected behavior is that it invokes selector on each element of source and returns the sum of the resulting values.

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.

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static Nullable<long> Sum(System::Linq::IQueryable<TSource> ^ source, System::Linq::Expressions::Expression<Func<TSource, Nullable<long>> ^> ^ selector);
public static Nullable<long> Sum<TSource> (this System.Linq.IQueryable<TSource> source, System.Linq.Expressions.Expression<Func<TSource,Nullable<long>>> selector);
static member Sum : System.Linq.IQueryable<'Source> * System.Linq.Expressions.Expression<Func<'Source, Nullable<int64>>> -> Nullable<int64>
<Extension()>
Public Function Sum(Of TSource) (source As IQueryable(Of TSource), selector As Expression(Of Func(Of TSource, Nullable(Of Long)))) As Nullable(Of Long)

類型參數

TSource

source 項目的類型。The type of the elements of source.

參數

source
IQueryable<TSource>

型別 TSource 的值序列。A sequence of values of type TSource.

selector
Expression<Func<TSource,Nullable<Int64>>>

要套用到每個項目的投影函式。A projection function to apply to each element.

傳回

預計值的總合。The sum of the projected values.

例外狀況

sourceselectornullsource or selector is null.

範例

下列程式碼範例示範如何使用Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)來加總序列的預測值。The following code example demonstrates how to use Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) to sum the projected values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要將此範例延伸到本主題中使用,請變更 selector 函式的主體。To extend the example to this topic, change the body of the selector function.

class Package
{
    public string Company { get; set; }
    public double Weight { get; set; }
}

public static void SumEx3()
{
    List<Package> packages =
        new List<Package> 
            { new Package { Company = "Coho Vineyard", Weight = 25.2 },
              new Package { Company = "Lucerne Publishing", Weight = 18.7 },
              new Package { Company = "Wingtip Toys", Weight = 6.0 },
              new Package { Company = "Adventure Works", Weight = 33.8 } };

    // Calculate the sum of all package weights.
    double totalWeight = packages.AsQueryable().Sum(pkg => pkg.Weight);

    Console.WriteLine("The total weight of the packages is: {0}", totalWeight);
}

/*
    This code produces the following output:

    The total weight of the packages is: 83.7
*/

Structure Package
    Public Company As String
    Public Weight As Double
End Structure

Shared Sub SumEx3()
    Dim packages As New List(Of Package)(New Package() { _
            New Package With {.Company = "Coho Vineyard", .Weight = 25.2}, _
              New Package With {.Company = "Lucerne Publishing", .Weight = 18.7}, _
              New Package With {.Company = "Wingtip Toys", .Weight = 6.0}, _
              New Package With {.Company = "Adventure Works", .Weight = 33.8}})

    ' Calculate the sum of all package weights.
    Dim totalWeight As Double = packages.AsQueryable().Sum(Function(pkg) pkg.Weight)

    MsgBox("The total weight of the packages is: " & totalWeight)
End Sub

'This code produces the following output:

'The total weight of the packages is: 83.7

備註

這個方法至少有一個類型Expression<TDelegate>的參數, 其類型引數是其中一個Func<T,TResult>類型。This method has at least one parameter of type Expression<TDelegate> whose type argument is one of the Func<T,TResult> types. 針對這些參數, 您可以傳入 lambda 運算式, 它會編譯成Expression<TDelegate>For these parameters, you can pass in a lambda expression and it will be compiled to an Expression<TDelegate>.

方法會產生, 其代表以Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>)The Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>) method generates a MethodCallExpression that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int64>>>) depends on the implementation of the type of the source parameter. 預期的行為是它selector會在的source每個專案上叫用, 並傳回產生之值的總和。The expected behavior is that it invokes selector on each element of source and returns the sum of the resulting values.

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.

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static Nullable<int> Sum(System::Linq::IQueryable<TSource> ^ source, System::Linq::Expressions::Expression<Func<TSource, Nullable<int>> ^> ^ selector);
public static Nullable<int> Sum<TSource> (this System.Linq.IQueryable<TSource> source, System.Linq.Expressions.Expression<Func<TSource,Nullable<int>>> selector);
static member Sum : System.Linq.IQueryable<'Source> * System.Linq.Expressions.Expression<Func<'Source, Nullable<int>>> -> Nullable<int>
<Extension()>
Public Function Sum(Of TSource) (source As IQueryable(Of TSource), selector As Expression(Of Func(Of TSource, Nullable(Of Integer)))) As Nullable(Of Integer)

類型參數

TSource

source 項目的類型。The type of the elements of source.

參數

source
IQueryable<TSource>

型別 TSource 的值序列。A sequence of values of type TSource.

selector
Expression<Func<TSource,Nullable<Int32>>>

要套用到每個項目的投影函式。A projection function to apply to each element.

傳回

預計值的總合。The sum of the projected values.

例外狀況

sourceselectornullsource or selector is null.

範例

下列程式碼範例示範如何使用Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)來加總序列的預測值。The following code example demonstrates how to use Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) to sum the projected values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要將此範例延伸到本主題中使用,請變更 selector 函式的主體。To extend the example to this topic, change the body of the selector function.

class Package
{
    public string Company { get; set; }
    public double Weight { get; set; }
}

public static void SumEx3()
{
    List<Package> packages =
        new List<Package> 
            { new Package { Company = "Coho Vineyard", Weight = 25.2 },
              new Package { Company = "Lucerne Publishing", Weight = 18.7 },
              new Package { Company = "Wingtip Toys", Weight = 6.0 },
              new Package { Company = "Adventure Works", Weight = 33.8 } };

    // Calculate the sum of all package weights.
    double totalWeight = packages.AsQueryable().Sum(pkg => pkg.Weight);

    Console.WriteLine("The total weight of the packages is: {0}", totalWeight);
}

/*
    This code produces the following output:

    The total weight of the packages is: 83.7
*/

Structure Package
    Public Company As String
    Public Weight As Double
End Structure

Shared Sub SumEx3()
    Dim packages As New List(Of Package)(New Package() { _
            New Package With {.Company = "Coho Vineyard", .Weight = 25.2}, _
              New Package With {.Company = "Lucerne Publishing", .Weight = 18.7}, _
              New Package With {.Company = "Wingtip Toys", .Weight = 6.0}, _
              New Package With {.Company = "Adventure Works", .Weight = 33.8}})

    ' Calculate the sum of all package weights.
    Dim totalWeight As Double = packages.AsQueryable().Sum(Function(pkg) pkg.Weight)

    MsgBox("The total weight of the packages is: " & totalWeight)
End Sub

'This code produces the following output:

'The total weight of the packages is: 83.7

備註

這個方法至少有一個類型Expression<TDelegate>的參數, 其類型引數是其中一個Func<T,TResult>類型。This method has at least one parameter of type Expression<TDelegate> whose type argument is one of the Func<T,TResult> types. 針對這些參數, 您可以傳入 lambda 運算式, 它會編譯成Expression<TDelegate>For these parameters, you can pass in a lambda expression and it will be compiled to an Expression<TDelegate>.

方法會產生, 其代表以Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>)The Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>) method generates a MethodCallExpression that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Int32>>>) depends on the implementation of the type of the source parameter. 預期的行為是它selector會在的source每個專案上叫用, 並傳回產生之值的總和。The expected behavior is that it invokes selector on each element of source and returns the sum of the resulting values.

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.

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static Nullable<double> Sum(System::Linq::IQueryable<TSource> ^ source, System::Linq::Expressions::Expression<Func<TSource, Nullable<double>> ^> ^ selector);
public static Nullable<double> Sum<TSource> (this System.Linq.IQueryable<TSource> source, System.Linq.Expressions.Expression<Func<TSource,Nullable<double>>> selector);
static member Sum : System.Linq.IQueryable<'Source> * System.Linq.Expressions.Expression<Func<'Source, Nullable<double>>> -> Nullable<double>
<Extension()>
Public Function Sum(Of TSource) (source As IQueryable(Of TSource), selector As Expression(Of Func(Of TSource, Nullable(Of Double)))) As Nullable(Of Double)

類型參數

TSource

source 項目的類型。The type of the elements of source.

參數

source
IQueryable<TSource>

型別 TSource 的值序列。A sequence of values of type TSource.

selector
Expression<Func<TSource,Nullable<Double>>>

要套用到每個項目的投影函式。A projection function to apply to each element.

傳回

預計值的總合。The sum of the projected values.

例外狀況

sourceselectornullsource or selector is null.

範例

下列程式碼範例示範如何使用Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)來加總序列的預測值。The following code example demonstrates how to use Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) to sum the projected values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要將此範例延伸到本主題中使用,請變更 selector 函式的主體。To extend the example to this topic, change the body of the selector function.

class Package
{
    public string Company { get; set; }
    public double Weight { get; set; }
}

public static void SumEx3()
{
    List<Package> packages =
        new List<Package> 
            { new Package { Company = "Coho Vineyard", Weight = 25.2 },
              new Package { Company = "Lucerne Publishing", Weight = 18.7 },
              new Package { Company = "Wingtip Toys", Weight = 6.0 },
              new Package { Company = "Adventure Works", Weight = 33.8 } };

    // Calculate the sum of all package weights.
    double totalWeight = packages.AsQueryable().Sum(pkg => pkg.Weight);

    Console.WriteLine("The total weight of the packages is: {0}", totalWeight);
}

/*
    This code produces the following output:

    The total weight of the packages is: 83.7
*/

Structure Package
    Public Company As String
    Public Weight As Double
End Structure

Shared Sub SumEx3()
    Dim packages As New List(Of Package)(New Package() { _
            New Package With {.Company = "Coho Vineyard", .Weight = 25.2}, _
              New Package With {.Company = "Lucerne Publishing", .Weight = 18.7}, _
              New Package With {.Company = "Wingtip Toys", .Weight = 6.0}, _
              New Package With {.Company = "Adventure Works", .Weight = 33.8}})

    ' Calculate the sum of all package weights.
    Dim totalWeight As Double = packages.AsQueryable().Sum(Function(pkg) pkg.Weight)

    MsgBox("The total weight of the packages is: " & totalWeight)
End Sub

'This code produces the following output:

'The total weight of the packages is: 83.7

備註

這個方法至少有一個類型Expression<TDelegate>的參數, 其類型引數是其中一個Func<T,TResult>類型。This method has at least one parameter of type Expression<TDelegate> whose type argument is one of the Func<T,TResult> types. 針對這些參數, 您可以傳入 lambda 運算式, 它會編譯成Expression<TDelegate>For these parameters, you can pass in a lambda expression and it will be compiled to an Expression<TDelegate>.

方法會產生, 其代表以Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>)The Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>) method generates a MethodCallExpression that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Double>>>) depends on the implementation of the type of the source parameter. 預期的行為是它selector會在的source每個專案上叫用, 並傳回產生之值的總和。The expected behavior is that it invokes selector on each element of source and returns the sum of the resulting values.

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.

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static float Sum(System::Linq::IQueryable<TSource> ^ source, System::Linq::Expressions::Expression<Func<TSource, float> ^> ^ selector);
public static float Sum<TSource> (this System.Linq.IQueryable<TSource> source, System.Linq.Expressions.Expression<Func<TSource,float>> selector);
static member Sum : System.Linq.IQueryable<'Source> * System.Linq.Expressions.Expression<Func<'Source, single>> -> single
<Extension()>
Public Function Sum(Of TSource) (source As IQueryable(Of TSource), selector As Expression(Of Func(Of TSource, Single))) As Single

類型參數

TSource

source 項目的類型。The type of the elements of source.

參數

source
IQueryable<TSource>

型別 TSource 的值序列。A sequence of values of type TSource.

selector
Expression<Func<TSource,Single>>

要套用到每個項目的投影函式。A projection function to apply to each element.

傳回

預計值的總合。The sum of the projected values.

例外狀況

sourceselectornullsource or selector is null.

範例

下列程式碼範例示範如何使用Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)來加總序列的預測值。The following code example demonstrates how to use Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) to sum the projected values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要將此範例延伸到本主題中使用,請變更 selector 函式的主體。To extend the example to this topic, change the body of the selector function.

class Package
{
    public string Company { get; set; }
    public double Weight { get; set; }
}

public static void SumEx3()
{
    List<Package> packages =
        new List<Package> 
            { new Package { Company = "Coho Vineyard", Weight = 25.2 },
              new Package { Company = "Lucerne Publishing", Weight = 18.7 },
              new Package { Company = "Wingtip Toys", Weight = 6.0 },
              new Package { Company = "Adventure Works", Weight = 33.8 } };

    // Calculate the sum of all package weights.
    double totalWeight = packages.AsQueryable().Sum(pkg => pkg.Weight);

    Console.WriteLine("The total weight of the packages is: {0}", totalWeight);
}

/*
    This code produces the following output:

    The total weight of the packages is: 83.7
*/

Structure Package
    Public Company As String
    Public Weight As Double
End Structure

Shared Sub SumEx3()
    Dim packages As New List(Of Package)(New Package() { _
            New Package With {.Company = "Coho Vineyard", .Weight = 25.2}, _
              New Package With {.Company = "Lucerne Publishing", .Weight = 18.7}, _
              New Package With {.Company = "Wingtip Toys", .Weight = 6.0}, _
              New Package With {.Company = "Adventure Works", .Weight = 33.8}})

    ' Calculate the sum of all package weights.
    Dim totalWeight As Double = packages.AsQueryable().Sum(Function(pkg) pkg.Weight)

    MsgBox("The total weight of the packages is: " & totalWeight)
End Sub

'This code produces the following output:

'The total weight of the packages is: 83.7

備註

這個方法至少有一個類型Expression<TDelegate>的參數, 其類型引數是其中一個Func<T,TResult>類型。This method has at least one parameter of type Expression<TDelegate> whose type argument is one of the Func<T,TResult> types. 針對這些參數, 您可以傳入 lambda 運算式, 它會編譯成Expression<TDelegate>For these parameters, you can pass in a lambda expression and it will be compiled to an Expression<TDelegate>.

方法會產生, 其代表以Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>)The Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>) method generates a MethodCallExpression that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Single>>) depends on the implementation of the type of the source parameter. 預期的行為是它selector會在的source每個專案上叫用, 並傳回產生之值的總和。The expected behavior is that it invokes selector on each element of source and returns the sum of the resulting values.

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.

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static long Sum(System::Linq::IQueryable<TSource> ^ source, System::Linq::Expressions::Expression<Func<TSource, long> ^> ^ selector);
public static long Sum<TSource> (this System.Linq.IQueryable<TSource> source, System.Linq.Expressions.Expression<Func<TSource,long>> selector);
static member Sum : System.Linq.IQueryable<'Source> * System.Linq.Expressions.Expression<Func<'Source, int64>> -> int64
<Extension()>
Public Function Sum(Of TSource) (source As IQueryable(Of TSource), selector As Expression(Of Func(Of TSource, Long))) As Long

類型參數

TSource

source 項目的類型。The type of the elements of source.

參數

source
IQueryable<TSource>

型別 TSource 的值序列。A sequence of values of type TSource.

selector
Expression<Func<TSource,Int64>>

要套用到每個項目的投影函式。A projection function to apply to each element.

傳回

預計值的總合。The sum of the projected values.

例外狀況

sourceselectornullsource or selector is null.

範例

下列程式碼範例示範如何使用Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)來加總序列的預測值。The following code example demonstrates how to use Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) to sum the projected values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要將此範例延伸到本主題中使用,請變更 selector 函式的主體。To extend the example to this topic, change the body of the selector function.

class Package
{
    public string Company { get; set; }
    public double Weight { get; set; }
}

public static void SumEx3()
{
    List<Package> packages =
        new List<Package> 
            { new Package { Company = "Coho Vineyard", Weight = 25.2 },
              new Package { Company = "Lucerne Publishing", Weight = 18.7 },
              new Package { Company = "Wingtip Toys", Weight = 6.0 },
              new Package { Company = "Adventure Works", Weight = 33.8 } };

    // Calculate the sum of all package weights.
    double totalWeight = packages.AsQueryable().Sum(pkg => pkg.Weight);

    Console.WriteLine("The total weight of the packages is: {0}", totalWeight);
}

/*
    This code produces the following output:

    The total weight of the packages is: 83.7
*/

Structure Package
    Public Company As String
    Public Weight As Double
End Structure

Shared Sub SumEx3()
    Dim packages As New List(Of Package)(New Package() { _
            New Package With {.Company = "Coho Vineyard", .Weight = 25.2}, _
              New Package With {.Company = "Lucerne Publishing", .Weight = 18.7}, _
              New Package With {.Company = "Wingtip Toys", .Weight = 6.0}, _
              New Package With {.Company = "Adventure Works", .Weight = 33.8}})

    ' Calculate the sum of all package weights.
    Dim totalWeight As Double = packages.AsQueryable().Sum(Function(pkg) pkg.Weight)

    MsgBox("The total weight of the packages is: " & totalWeight)
End Sub

'This code produces the following output:

'The total weight of the packages is: 83.7

備註

這個方法至少有一個類型Expression<TDelegate>的參數, 其類型引數是其中一個Func<T,TResult>類型。This method has at least one parameter of type Expression<TDelegate> whose type argument is one of the Func<T,TResult> types. 針對這些參數, 您可以傳入 lambda 運算式, 它會編譯成Expression<TDelegate>For these parameters, you can pass in a lambda expression and it will be compiled to an Expression<TDelegate>.

方法會產生, 其代表以Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>)The Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>) method generates a MethodCallExpression that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int64>>) depends on the implementation of the type of the source parameter. 預期的行為是它selector會在的source每個專案上叫用, 並傳回產生之值的總和。The expected behavior is that it invokes selector on each element of source and returns the sum of the resulting values.

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.

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static int Sum(System::Linq::IQueryable<TSource> ^ source, System::Linq::Expressions::Expression<Func<TSource, int> ^> ^ selector);
public static int Sum<TSource> (this System.Linq.IQueryable<TSource> source, System.Linq.Expressions.Expression<Func<TSource,int>> selector);
static member Sum : System.Linq.IQueryable<'Source> * System.Linq.Expressions.Expression<Func<'Source, int>> -> int
<Extension()>
Public Function Sum(Of TSource) (source As IQueryable(Of TSource), selector As Expression(Of Func(Of TSource, Integer))) As Integer

類型參數

TSource

source 項目的類型。The type of the elements of source.

參數

source
IQueryable<TSource>

型別 TSource 的值序列。A sequence of values of type TSource.

selector
Expression<Func<TSource,Int32>>

要套用到每個項目的投影函式。A projection function to apply to each element.

傳回

預計值的總合。The sum of the projected values.

例外狀況

sourceselectornullsource or selector is null.

範例

下列程式碼範例示範如何使用Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)來加總序列的預測值。The following code example demonstrates how to use Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) to sum the projected values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要將此範例延伸到本主題中使用,請變更 selector 函式的主體。To extend the example to this topic, change the body of the selector function.

class Package
{
    public string Company { get; set; }
    public double Weight { get; set; }
}

public static void SumEx3()
{
    List<Package> packages =
        new List<Package> 
            { new Package { Company = "Coho Vineyard", Weight = 25.2 },
              new Package { Company = "Lucerne Publishing", Weight = 18.7 },
              new Package { Company = "Wingtip Toys", Weight = 6.0 },
              new Package { Company = "Adventure Works", Weight = 33.8 } };

    // Calculate the sum of all package weights.
    double totalWeight = packages.AsQueryable().Sum(pkg => pkg.Weight);

    Console.WriteLine("The total weight of the packages is: {0}", totalWeight);
}

/*
    This code produces the following output:

    The total weight of the packages is: 83.7
*/

Structure Package
    Public Company As String
    Public Weight As Double
End Structure

Shared Sub SumEx3()
    Dim packages As New List(Of Package)(New Package() { _
            New Package With {.Company = "Coho Vineyard", .Weight = 25.2}, _
              New Package With {.Company = "Lucerne Publishing", .Weight = 18.7}, _
              New Package With {.Company = "Wingtip Toys", .Weight = 6.0}, _
              New Package With {.Company = "Adventure Works", .Weight = 33.8}})

    ' Calculate the sum of all package weights.
    Dim totalWeight As Double = packages.AsQueryable().Sum(Function(pkg) pkg.Weight)

    MsgBox("The total weight of the packages is: " & totalWeight)
End Sub

'This code produces the following output:

'The total weight of the packages is: 83.7

備註

這個方法至少有一個類型Expression<TDelegate>的參數, 其類型引數是其中一個Func<T,TResult>類型。This method has at least one parameter of type Expression<TDelegate> whose type argument is one of the Func<T,TResult> types. 針對這些參數, 您可以傳入 lambda 運算式, 它會編譯成Expression<TDelegate>For these parameters, you can pass in a lambda expression and it will be compiled to an Expression<TDelegate>.

方法會產生, 其代表以Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>)The Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>) method generates a MethodCallExpression that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Int32>>) depends on the implementation of the type of the source parameter. 預期的行為是它selector會在的source每個專案上叫用, 並傳回產生之值的總和。The expected behavior is that it invokes selector on each element of source and returns the sum of the resulting values.

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.

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static double Sum(System::Linq::IQueryable<TSource> ^ source, System::Linq::Expressions::Expression<Func<TSource, double> ^> ^ selector);
public static double Sum<TSource> (this System.Linq.IQueryable<TSource> source, System.Linq.Expressions.Expression<Func<TSource,double>> selector);
static member Sum : System.Linq.IQueryable<'Source> * System.Linq.Expressions.Expression<Func<'Source, double>> -> double
<Extension()>
Public Function Sum(Of TSource) (source As IQueryable(Of TSource), selector As Expression(Of Func(Of TSource, Double))) As Double

類型參數

TSource

source 項目的類型。The type of the elements of source.

參數

source
IQueryable<TSource>

型別 TSource 的值序列。A sequence of values of type TSource.

selector
Expression<Func<TSource,Double>>

要套用到每個項目的投影函式。A projection function to apply to each element.

傳回

預計值的總合。The sum of the projected values.

例外狀況

sourceselectornullsource or selector is null.

範例

下列程式碼範例示範如何使用Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)來加總序列的預測值。The following code example demonstrates how to use Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) to sum the projected values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要將此範例延伸到本主題中使用,請變更 selector 函式的主體。To extend the example to this topic, change the body of the selector function.

class Package
{
    public string Company { get; set; }
    public double Weight { get; set; }
}

public static void SumEx3()
{
    List<Package> packages =
        new List<Package> 
            { new Package { Company = "Coho Vineyard", Weight = 25.2 },
              new Package { Company = "Lucerne Publishing", Weight = 18.7 },
              new Package { Company = "Wingtip Toys", Weight = 6.0 },
              new Package { Company = "Adventure Works", Weight = 33.8 } };

    // Calculate the sum of all package weights.
    double totalWeight = packages.AsQueryable().Sum(pkg => pkg.Weight);

    Console.WriteLine("The total weight of the packages is: {0}", totalWeight);
}

/*
    This code produces the following output:

    The total weight of the packages is: 83.7
*/

Structure Package
    Public Company As String
    Public Weight As Double
End Structure

Shared Sub SumEx3()
    Dim packages As New List(Of Package)(New Package() { _
            New Package With {.Company = "Coho Vineyard", .Weight = 25.2}, _
              New Package With {.Company = "Lucerne Publishing", .Weight = 18.7}, _
              New Package With {.Company = "Wingtip Toys", .Weight = 6.0}, _
              New Package With {.Company = "Adventure Works", .Weight = 33.8}})

    ' Calculate the sum of all package weights.
    Dim totalWeight As Double = packages.AsQueryable().Sum(Function(pkg) pkg.Weight)

    MsgBox("The total weight of the packages is: " & totalWeight)
End Sub

'This code produces the following output:

'The total weight of the packages is: 83.7

備註

這個方法至少有一個類型Expression<TDelegate>的參數, 其類型引數是其中一個Func<T,TResult>類型。This method has at least one parameter of type Expression<TDelegate> whose type argument is one of the Func<T,TResult> types. 針對這些參數, 您可以傳入 lambda 運算式, 它會編譯成Expression<TDelegate>For these parameters, you can pass in a lambda expression and it will be compiled to an Expression<TDelegate>.

方法會產生, 其代表以Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)The Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) method generates a MethodCallExpression that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)之運算式樹狀架構而產生的查詢行為, 取決於其source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) depends on the implementation of the type of he source parameter. 預期的行為是它selector會在的source每個專案上叫用, 並傳回產生之值的總和。The expected behavior is that it invokes selector on each element of source and returns the sum of the resulting values.

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.

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static System::Decimal Sum(System::Linq::IQueryable<TSource> ^ source, System::Linq::Expressions::Expression<Func<TSource, System::Decimal> ^> ^ selector);
public static decimal Sum<TSource> (this System.Linq.IQueryable<TSource> source, System.Linq.Expressions.Expression<Func<TSource,decimal>> selector);
static member Sum : System.Linq.IQueryable<'Source> * System.Linq.Expressions.Expression<Func<'Source, decimal>> -> decimal
<Extension()>
Public Function Sum(Of TSource) (source As IQueryable(Of TSource), selector As Expression(Of Func(Of TSource, Decimal))) As Decimal

類型參數

TSource

source 項目的類型。The type of the elements of source.

參數

source
IQueryable<TSource>

型別 TSource 的值序列。A sequence of values of type TSource.

selector
Expression<Func<TSource,Decimal>>

要套用到每個項目的投影函式。A projection function to apply to each element.

傳回

預計值的總合。The sum of the projected values.

例外狀況

sourceselectornullsource or selector is null.

範例

下列程式碼範例示範如何使用Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)來加總序列的預測值。The following code example demonstrates how to use Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) to sum the projected values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要將此範例延伸到本主題中使用,請變更 selector 函式的主體。To extend the example to this topic, change the body of the selector function.

class Package
{
    public string Company { get; set; }
    public double Weight { get; set; }
}

public static void SumEx3()
{
    List<Package> packages =
        new List<Package> 
            { new Package { Company = "Coho Vineyard", Weight = 25.2 },
              new Package { Company = "Lucerne Publishing", Weight = 18.7 },
              new Package { Company = "Wingtip Toys", Weight = 6.0 },
              new Package { Company = "Adventure Works", Weight = 33.8 } };

    // Calculate the sum of all package weights.
    double totalWeight = packages.AsQueryable().Sum(pkg => pkg.Weight);

    Console.WriteLine("The total weight of the packages is: {0}", totalWeight);
}

/*
    This code produces the following output:

    The total weight of the packages is: 83.7
*/

Structure Package
    Public Company As String
    Public Weight As Double
End Structure

Shared Sub SumEx3()
    Dim packages As New List(Of Package)(New Package() { _
            New Package With {.Company = "Coho Vineyard", .Weight = 25.2}, _
              New Package With {.Company = "Lucerne Publishing", .Weight = 18.7}, _
              New Package With {.Company = "Wingtip Toys", .Weight = 6.0}, _
              New Package With {.Company = "Adventure Works", .Weight = 33.8}})

    ' Calculate the sum of all package weights.
    Dim totalWeight As Double = packages.AsQueryable().Sum(Function(pkg) pkg.Weight)

    MsgBox("The total weight of the packages is: " & totalWeight)
End Sub

'This code produces the following output:

'The total weight of the packages is: 83.7

備註

這個方法至少有一個類型Expression<TDelegate>的參數, 其類型引數是其中一個Func<T,TResult>類型。This method has at least one parameter of type Expression<TDelegate> whose type argument is one of the Func<T,TResult> types. 針對這些參數, 您可以傳入 lambda 運算式, 它會編譯成Expression<TDelegate>For these parameters, you can pass in a lambda expression and it will be compiled to an Expression<TDelegate>.

方法會產生, 其代表以Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>)The Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) method generates a MethodCallExpression that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Decimal>>) depends on the implementation of the type of the source parameter. 預期的行為是它selector會在的source每個專案上叫用, 並傳回產生之值的總和。The expected behavior is that it invokes selector on each element of source and returns the sum of the resulting values.

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.

public:
generic <typename TSource>
[System::Runtime::CompilerServices::Extension]
 static Nullable<System::Decimal> Sum(System::Linq::IQueryable<TSource> ^ source, System::Linq::Expressions::Expression<Func<TSource, Nullable<System::Decimal>> ^> ^ selector);
public static Nullable<decimal> Sum<TSource> (this System.Linq.IQueryable<TSource> source, System.Linq.Expressions.Expression<Func<TSource,Nullable<decimal>>> selector);
static member Sum : System.Linq.IQueryable<'Source> * System.Linq.Expressions.Expression<Func<'Source, Nullable<decimal>>> -> Nullable<decimal>
<Extension()>
Public Function Sum(Of TSource) (source As IQueryable(Of TSource), selector As Expression(Of Func(Of TSource, Nullable(Of Decimal)))) As Nullable(Of Decimal)

類型參數

TSource

source 項目的類型。The type of the elements of source.

參數

source
IQueryable<TSource>

型別 TSource 的值序列。A sequence of values of type TSource.

selector
Expression<Func<TSource,Nullable<Decimal>>>

要套用到每個項目的投影函式。A projection function to apply to each element.

傳回

預計值的總合。The sum of the projected values.

例外狀況

sourceselectornullsource or selector is null.

範例

下列程式碼範例示範如何使用Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>)來加總序列的預測值。The following code example demonstrates how to use Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Double>>) to sum the projected values of a sequence.

注意

這個程式碼範例會使用此多載方法的多載,這個多載不是本主題描述的特定多載。This code example uses an overload of this overloaded method that is different from the specific overload that this topic describes. 若要將此範例延伸到本主題中使用,請變更 selector 函式的主體。To extend the example to this topic, change the body of the selector function.

class Package
{
    public string Company { get; set; }
    public double Weight { get; set; }
}

public static void SumEx3()
{
    List<Package> packages =
        new List<Package> 
            { new Package { Company = "Coho Vineyard", Weight = 25.2 },
              new Package { Company = "Lucerne Publishing", Weight = 18.7 },
              new Package { Company = "Wingtip Toys", Weight = 6.0 },
              new Package { Company = "Adventure Works", Weight = 33.8 } };

    // Calculate the sum of all package weights.
    double totalWeight = packages.AsQueryable().Sum(pkg => pkg.Weight);

    Console.WriteLine("The total weight of the packages is: {0}", totalWeight);
}

/*
    This code produces the following output:

    The total weight of the packages is: 83.7
*/

Structure Package
    Public Company As String
    Public Weight As Double
End Structure

Shared Sub SumEx3()
    Dim packages As New List(Of Package)(New Package() { _
            New Package With {.Company = "Coho Vineyard", .Weight = 25.2}, _
              New Package With {.Company = "Lucerne Publishing", .Weight = 18.7}, _
              New Package With {.Company = "Wingtip Toys", .Weight = 6.0}, _
              New Package With {.Company = "Adventure Works", .Weight = 33.8}})

    ' Calculate the sum of all package weights.
    Dim totalWeight As Double = packages.AsQueryable().Sum(Function(pkg) pkg.Weight)

    MsgBox("The total weight of the packages is: " & totalWeight)
End Sub

'This code produces the following output:

'The total weight of the packages is: 83.7

備註

這個方法至少有一個類型Expression<TDelegate>的參數, 其類型引數是其中一個Func<T,TResult>類型。This method has at least one parameter of type Expression<TDelegate> whose type argument is one of the Func<T,TResult> types. 針對這些參數, 您可以傳入 lambda 運算式, 它會編譯成Expression<TDelegate>For these parameters, you can pass in a lambda expression and it will be compiled to an Expression<TDelegate>.

方法會產生, 其代表以Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>)結構化泛型方法的方式呼叫本身。 MethodCallExpression Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>)The Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>) method generates a MethodCallExpression that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>) itself as a constructed generic method. 然後, 它會MethodCallExpression將傳遞Execute<TResult>(Expression)至由Provider source參數IQueryProvider的屬性所表示之的方法。It then passes the MethodCallExpression to the Execute<TResult>(Expression) method of the IQueryProvider represented by the Provider property of the source parameter.

因執行代表呼叫Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>)之運算式樹狀架構而產生的查詢行為, 取決於source參數類型的實作為。The query behavior that occurs as a result of executing an expression tree that represents calling Sum<TSource>(IQueryable<TSource>, Expression<Func<TSource,Nullable<Decimal>>>) depends on the implementation of the type of the source parameter. 預期的行為是它selector會在的source每個專案上叫用, 並傳回產生之值的總和。The expected behavior is that it invokes selector on each element of source and returns the sum of the resulting values.

適用於