>select i.invoice_no, i.descrip1, i.date_time, > (select sum(isnull(t.extension,0.00)) from dbo.transact t where t.invoice_no=i.invoice_no) as extension, > i.finalized from dbo.invoices i>
> var invoicesList = _dbSet.Where(x => x.Account == accountName && x.Hidden == false). > Select(x => new InvoicesList { InvoiceNo = x.InvoiceNo, Account = x.Account, Hidden = x.Hidden, > Descrip = x.Descrip1, Finalized = x.Finalized, Created = x.DateTime}); > > if (showFinalized) > { > invoicesList = invoicesList.Where(x => x.Finalized == true); > }>
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();