Last post Jun 13, 2016 07:09 AM by Yohann Lu
Jun 11, 2016 05:46 PM|lberan|LINK
User is allowed to make multiple payments toward each invoice. I want to get total payment amount for an invoice. If no payment has been made toward this invoice, the result should return 0.
This is the sql query:
select isnull(sum(paymentAmount),0) from paymentInfoes where invoiceNum = 123
Could you convert this sql to linq for me? Thank you!
Jun 13, 2016 07:09 AM|Yohann Lu|LINK
You can try the following tools (SQL-> LINQ converter).
Linqer is a SQL to LINQ conversion tool. It helps learning LINQ and convert existing SQL statements.