需要帮助的转换使用LINQ

Question

这里一个TSQL查询英孚的查询：

select FC.Title, COUNT(FSC.ID) as FCCount, COUNT(FP.NoOfSub), MAX(FP.LastPost) 
from ForumCategories FC 
left join ForumSubCategories FSC on FSC.CategoryID_FK = FC.ID 
left join (select SubCategoryID_FK, Count(ID) NoOfSub, MAX(DatePosted) LastPost 
      from ForumPosts group by SubCategoryID_FK) FP 
on FP.SubCategoryID_FK = FSC.ID 
group by FC.Title 
order by FC.Title 

Answer 1

您可以使用LINQPad，它不支持ADO.NET实体框架：http://www.linqpad.net/

输入查询，并有是一个SQL选项卡，它是SQL转换。