Sum database column entries in c#

Question

I am new to SQL and databases. I have a table in SQL Server. In that table there is a column price. I want to sum all the price. What I tried is :

var totalAmount = db.Orders.Select(p => new { sum += p.Price });

What I am doing wrong here ?

Answer 1

You could try doing a .Sum like below:

var totalAmount = db.Orders.Select(p => p.Price ?? 0).Sum();

Similiar question at sum column with linq to sql

Answer 2

you should be using SUM (LiNQ Extension Method)

int total = db.Orders.Sum(p => p.Price);

Answer 3

var totalAmount = db.Orders.Sum(p => p.Price);