如何将此sql转换为linq [英] How to convert this sql to linq
本文介绍了如何将此sql转换为linq的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
select Name,openissues,TotalIssues,((openissues*100)/TotalIssues) as IssuePerc
from(
select Agencies.Name as Name,count(Agencies.Name)as openissues,
(select COUNT(*) from BackToOperations where IsResolved =0)as TotalIssues
from Agencies
join Claims
on Agencies.AgencyId=Claims.AgencyId
join BackToOperations
on Claims.ClaimId =BackToOperations.ClaimId
where IsResolved =0
group by Agencies.Name,IsResolved
) as X
推荐答案
帮助自己： http：/ /www.sqltolinq.com/ [ ^ ]
或
自己学习： conversion-sql-to-linq-part-1 [ ^ ]
Help yourself to this: http://www.sqltolinq.com/[^]
or
Learn it yourself: converting-sql-to-linq-part-1[^]
使用 LINQPad [ ^ ]
这篇关于如何将此sql转换为linq的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
