Hello,I want to run sql query to select list on accounts with automatic payment, open invoices of each account (append as string), count of invoices, total amount of invoices.There are 2 tables: tblAccount with accountNo and autopayment information.tlbInvoices with invoiceID, accountNo, amount.SQL query on database is like thisselect accountNo,[IC_invoices].[dbo].[ConcatOpenInvoice](accountno) as invoices,sum(totalAmount) as amount, count(Reference) as NumberofInvoices from [IC_invoices].[dbo].tblInvoice where accountNo in(select distinct accountno from [IC_invoices].[dbo].[tblAccount] where autopayment='yes') and paystatus is null group by accountNoConcatOpenInvoice is a function to append invoice ID of all open invoices under one account.Is it possible to convert this sql to linq.Thank you.
View Complete Post