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

Definition

数値のシーケンスの合計を計算します。 Computes the sum of a sequence of numeric values.

Overloads

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<Double>) Sum(IQueryable<Double>) Sum(IQueryable<Double>) Sum(IQueryable<Double>)

Double 値のシーケンスの合計を計算します。 Computes the sum of a sequence of Double 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<Int32>) Sum(IQueryable<Int32>) Sum(IQueryable<Int32>) Sum(IQueryable<Int32>)

Int32 値のシーケンスの合計を計算します。 Computes the sum of a sequence of Int32 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<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.

Returns

シーケンスの値の合計。 The sum of the values in the sequence.

Exceptions

Examples

次のコード例は、使用する方法を示します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.

Remarks

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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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.

Returns

シーケンスの値の合計。 The sum of the values in the sequence.

Exceptions

Examples

次のコード例は、使用する方法を示します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

Remarks

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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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.

Returns

シーケンスの値の合計。 The sum of the values in the sequence.

Exceptions

合計が MaxValue を超えています。 The sum is larger than MaxValue.

Examples

次のコード例は、使用する方法を示します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

Remarks

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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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.

Returns

シーケンスの値の合計。 The sum of the values in the sequence.

Exceptions

合計が MaxValue を超えています。 The sum is larger than MaxValue.

Examples

次のコード例は、使用する方法を示します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

Remarks

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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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.

Returns

シーケンスの値の合計。 The sum of the values in the sequence.

Exceptions

Examples

次のコード例は、使用する方法を示します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

Remarks

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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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<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.

Returns

シーケンスの値の合計。 The sum of the values in the sequence.

Exceptions

Examples

次のコード例は、使用する方法を示します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.

Remarks

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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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<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.

Returns

シーケンスの値の合計。 The sum of the values in the sequence.

Exceptions

合計が MaxValue を超えています。 The sum is larger than MaxValue.

Examples

次のコード例は、使用する方法を示します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.

Remarks

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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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<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.

Returns

シーケンスの値の合計。 The sum of the values in the sequence.

Exceptions

合計が MaxValue を超えています。 The sum is larger than MaxValue.

Examples

次のコード例は、使用する方法を示します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.

Remarks

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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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<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.

Returns

シーケンスの値の合計。 The sum of the values in the sequence.

Exceptions

合計が MaxValue を超えています。 The sum is larger than MaxValue.

Examples

次のコード例は、使用する方法を示します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

Remarks

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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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<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.

Returns

シーケンスの値の合計。 The sum of the values in the sequence.

Exceptions

合計が MaxValue を超えています。 The sum is larger than MaxValue.

Examples

次のコード例は、使用する方法を示します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.

Remarks

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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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)

Type Parameters

TSource

要素の型ソースします。 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.

Returns

射影された値の合計。 The sum of the projected values.

Exceptions

source または selectornull です。 source or selector is null.

Examples

次のコード例は、使用する方法を示します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

Remarks

このメソッドは、少なくとも 1 つのパラメーター型の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. ラムダ式で、これらのパラメーターを渡すことができますにコンパイルされると、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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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)

Type Parameters

TSource

要素の型ソースします。 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.

Returns

射影された値の合計。 The sum of the projected values.

Exceptions

source または selectornull です。 source or selector is null.

合計が MaxValue を超えています。 The sum is larger than MaxValue.

Examples

次のコード例は、使用する方法を示します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

Remarks

このメソッドは、少なくとも 1 つのパラメーター型の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. ラムダ式で、これらのパラメーターを渡すことができますにコンパイルされると、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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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)

Type Parameters

TSource

要素の型ソースします。 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.

Returns

射影された値の合計。 The sum of the projected values.

Exceptions

source または selectornull です。 source or selector is null.

合計が MaxValue を超えています。 The sum is larger than MaxValue.

Examples

次のコード例は、使用する方法を示します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

Remarks

このメソッドは、少なくとも 1 つのパラメーター型の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. ラムダ式で、これらのパラメーターを渡すことができますにコンパイルされると、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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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)

Type Parameters

TSource

要素の型ソースします。 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.

Returns

射影された値の合計。 The sum of the projected values.

Exceptions

source または selectornull です。 source or selector is null.

Examples

次のコード例は、使用する方法を示します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

Remarks

このメソッドは、少なくとも 1 つのパラメーター型の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. ラムダ式で、これらのパラメーターを渡すことができますにコンパイルされると、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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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

Type Parameters

TSource

要素の型ソースします。 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.

Returns

射影された値の合計。 The sum of the projected values.

Exceptions

source または selectornull です。 source or selector is null.

Examples

次のコード例は、使用する方法を示します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

Remarks

このメソッドは、少なくとも 1 つのパラメーター型の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. ラムダ式で、これらのパラメーターを渡すことができますにコンパイルされると、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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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

Type Parameters

TSource

要素の型ソースします。 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.

Returns

射影された値の合計。 The sum of the projected values.

Exceptions

source または selectornull です。 source or selector is null.

合計が MaxValue を超えています。 The sum is larger than MaxValue.

Examples

次のコード例は、使用する方法を示します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

Remarks

このメソッドは、少なくとも 1 つのパラメーター型の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. ラムダ式で、これらのパラメーターを渡すことができますにコンパイルされると、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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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

Type Parameters

TSource

要素の型ソースします。 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.

Returns

射影された値の合計。 The sum of the projected values.

Exceptions

source または selectornull です。 source or selector is null.

合計が MaxValue を超えています。 The sum is larger than MaxValue.

Examples

次のコード例は、使用する方法を示します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

Remarks

このメソッドは、少なくとも 1 つのパラメーター型の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. ラムダ式で、これらのパラメーターを渡すことができますにコンパイルされると、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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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

Type Parameters

TSource

要素の型ソースします。 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.

Returns

射影された値の合計。 The sum of the projected values.

Exceptions

source または selectornull です。 source or selector is null.

Examples

次のコード例は、使用する方法を示します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

Remarks

このメソッドは、少なくとも 1 つのパラメーター型の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. ラムダ式で、これらのパラメーターを渡すことができますにコンパイルされると、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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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

Type Parameters

TSource

要素の型ソースします。 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.

Returns

射影された値の合計。 The sum of the projected values.

Exceptions

source または selectornull です。 source or selector is null.

合計が MaxValue を超えています。 The sum is larger than MaxValue.

Examples

次のコード例は、使用する方法を示します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

Remarks

このメソッドは、少なくとも 1 つのパラメーター型の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. ラムダ式で、これらのパラメーターを渡すことができますにコンパイルされると、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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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)

Type Parameters

TSource

要素の型ソースします。 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.

Returns

射影された値の合計。 The sum of the projected values.

Exceptions

source または selectornull です。 source or selector is null.

合計が MaxValue を超えています。 The sum is larger than MaxValue.

Examples

次のコード例は、使用する方法を示します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

Remarks

このメソッドは、少なくとも 1 つのパラメーター型の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. ラムダ式で、これらのパラメーターを渡すことができますにコンパイルされると、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. これは、後、渡します、MethodCallExpressionExecute<TResult>(Expression)のメソッド、IQueryProviderによって表される、Providerのプロパティ、sourceパラメーター。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.

Applies to