任何人都可以将此查询转换为linq查询 [英] Can anyone please convert this query to linq query

问题描述

任何人都可以将此查询转换为linq查询

Can anyone please convert this query to linq query

SELECT i.CustomerID, i.InvoiceDate, i.InvoiceID, i.Particulars,
i.Value, i.TaxAmount, i.TotalAmount, col.ReceivedAmount,(i.TotalAmount-col.ReceivedAmount) as 'Balance Amount'  FROM 
(select invoiceid, SUM(receivedamount) as 'ReceivedAmount' from tbCollections group by invoiceid) col
JOIN tbInvoice i ON i.InvoiceID=col.InvoiceID

提前感谢..

Thanx in advance..

推荐答案

在这里，请查看这篇文章
学习从SQL到LINQ(视觉表示) [

Here you go, check this article
Learn SQL to LINQ (Visual Representation)[^]

这篇关于任何人都可以将此查询转换为linq查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！