>>>var list = (from d in _dbSet.Where(x => x.Account == accountName && x.Hidden == false) >>> from t in transact .Sum(s=>s.extension).Where(w=>w.extension != null && w.invoiceNo == d.InvoiceNo). >>> select(x => new InvoicesList { InvoiceNo = x.InvoiceNo, Account = x.Account, Hidden = x.Hidden, >>> Descrip = x.Descrip1, Finalized = x.Finalized, Created = .DateTime}, InvoiceBalance= t)).ToList(); >>>>>
>> var invoicesList = (from d in _dbSet.Where(x => x.Account == accountName && x.Hidden == false) >> from i in _siriusContext.Transact.Where(w=>w.Extension != null && w.InvoiceNo == d.InvoiceNo) >> select(x => new InvoicesList { InvoiceNo = x.InvoiceNo, Account = x.Account, Hidden = x.Hidden, Descrip = x.Descrip1, Finalized = x.Finalized, Created = x.DateTime, Balance= i.Extension})) >>>