Sum Values using Linq Query

Question

Hi

I have 2 tables

Purchase Table - ItemCode, Qty Recd

Issue Table - ItemCode, Qty Issued

I want to group Data by ItemCode and then display data like below

ItemCode Qty Recd Qty Issued Qty Balance

1 10 2 8

2 4 4

Thanks

Sachin Singh · Answer

Ramco Ramco · Answer

Hi Muhammad It is giving error on context.view_details - could not find an implementation of the query pattern to source type table var total = (from PT in context.View_Details join IT in context.View_DeliveryDetails on PT.ItemCode equals IT.ItemCode group T3 by new { PT.ItemCode } into g select new { ItemCode = PT.ItemCode, QtyRecd = g.Sum(t3 => PT.QtyRecd), QtyIssued = g.Sum(t3 => IT.QtyIssued), QtyBalance = g.Sum(t3 => PT.QtyRecd) - g.Sum(t3 => IT.QtyIssued) } Thanks

Muhammad Imran Ansari · Answer

Try the following query: var total = from PT in context.PurchaseTable join IT in context.IssueTable on PT.ItemCode equals IT.ItemCode group T3 by new { PT.ItemCode } into g select new { ItemCode = PT.ItemCode, QtyRecd = g.Sum(t3 => PT.QtyRecd), QtyIssued = g.Sum(t3 => IT.QtyIssued), QtyBalance = g.Sum(t3 => PT.QtyRecd) - g.Sum(t3 => IT.QtyIssued) };