已下sql 转为linq to sql (各位大侠路过看看)

select 
      top 10 
  s.ID,s.CreateTime,
  count(sc.ID) SCount,
  count(p.ID) PCount,
  count(r.ID) RCount
from  
 s 
 left join  sc on s.id=sc.SubjectID
 left join  p  on s.id=p.SubjectID
 left join  r  on s.id=r.SubjectID
group by
      s.ID,s.CreateTime
order by   s.CreateTime desc
     

LINQ?to?SQL
[解决办法]
没时间写了，参考这个吧：

http://bbs.csdn.net/topics/390419148