How to use Sum Function In linq query With Join?

Hi mukesh,

Try this (not tested)


from stock in stocks
join master in _master on stock.materid equals _master.id
group stock by stock.materid
select new 
{
Master_ID = master.id,
Stock_SUM = stocks.Sum(stock.qty)
}
orderby Stock_SUM descending