本文介绍了如何将此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推荐答案
这篇关于如何将此sql转换为linq的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！