Linq to SQL Sum()

Question

select sum(Sales) from WeeklyProductSale. how i can write this query in linq and what this query will return to me.

thankas in advance.

Answer 1

var answer = db.WeeklyProductSales.Sum (s => s.Sales);

This will return a variable of type s.Sales (e.g., decimal).

Edit: if you querying a DataTable, you will need to do this:

myDataTable.AsEnumerable().Sum (row => (decimal) row["Sales"]).

Make sure you reference System.Data.DataSetExtensions.dll and put "using System.Data.DataSetExtensions" into your program because the AsEnumerable extension method that this query uses relies on this. Change (decimal) to the type of the Sales column.

Answer 2

VB.Net

Dim sumOfSales = Aggregate wps In db.WeeklyProductSale Into Sum(wps.Sales)

Answer 3

You can write it like this,

YourDBContextObject.WeeklyProductSales.Sum(w => w.Sales);