How to use Sum Function In linq query With Join?

Question

hey frnds.. I have two table one is item master and another is stock detail.. i want to join the both table and sum the all qty of item. means how i can use sum with join of two tables.....

Mukesh Kumar Tiwari · Answer

Not working Sir....

Anupam Singh · Answer

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