Sum Values using Linq Query

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

var res1= (from p in _context.Purchases

              join i in _context.Issues on

            p.ItemCode equals i.ItemCode select new

{

ItemCode=p.ItemCode,

QtyRecd =p.QtyRecd,

QtyIssued=i.QtyIssued

}).ToList();

public class MainVM

{

public int ItemCode {get;set;}

public int QtyRecd {get;set;}

public int QtyIssued {get;set;}

public int QtyBalance {get;set;}

}

 var resMain= (from a in res1  group a by ItemCode  into g

          select new MainVM

{

ItemCode=g.Key,

QtyRecd= (Int)Sum(x=>x.QtyRecd),

QtyIssued=(int)Sum(x=>x.QtyIssued),

QtyBalance=(Int)Sum(x=>x.QtyRecd)-(int)Sum(x=>x.QtyIssued)

}).ToList();

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)	
            };