forum

home / developersection / forums / how can i use sum () in linq?

Ask Question

How can I use Sum () in LINQ?

Revati S Misra 411 27-Jul-2023

How can I use Sum () in LINQ?

linq linq to sql

Updated on 28-Jul-2023

Revati S Misra

Student

Skilled in SEO, content writing, and digital marketing. Completed several years of working in many organizations including multinational companies. I love to learn new things in life that keep me motivated.

Can you answer this question?

Answer

1 Answers

Aryan Kumar

28-Jul-2023

The Sum() method in LINQ is used to calculate the sum of a sequence of values. It can be used with any sequence of numeric values, such as integers, floats, doubles, and decimals.

The syntax for the Sum() method is as follows:

var sum = sequence.Sum(selector);

The sequence parameter is the sequence of values that you want to sum. The selector parameter is a function that takes a single element from the sequence and returns a numeric value.

For example, the following code uses the Sum() method to calculate the sum of all the numbers in an array:

int[] numbers = { 1, 2, 3, 4, 5 };
var sum = numbers.Sum(x => x);

This code will first create an array of integers called numbers. Then, it will use the Sum() method to calculate the sum of all the numbers in the array. Finally, it will store the sum in a variable called sum.

The Sum() method can also be used with LINQ queries. For example, the following code uses the Sum() method to calculate the sum of all the prices in a table of products:

var products = new LinqToSqlSumDataContext().Products;
var sum = products.Sum(x => x.Price);

This code will first create a LINQ query for the products table. Then, it will use the Sum() method to calculate the sum of all the prices in the table. Finally, it will store the sum in a variable called sum.

forum

How can I use Sum () in LINQ?

Revati S Misra

Can you answer this question?

1 Answers

Liked By