求助, SQL转Linq

Question

SELECT
c.id,
c.CustomersName as name,
f.FollowUpTheWay as names,
f.NextFollowDate,
f.FollowDate,
f.id as fid
from dbo.Slgl_CustomerReception as c 
left join dbo.Slgl_FollowUpRecords as f on f.CustomersId = c.id and 
    f.id = (select TOP(1) id from dbo.Slgl_FollowUpRecords where CustomersId = c.id and FollowDate <= '2011-7-20' order by id DESC)
where c.ProjectId = 9

如何转成linq 或 linq to ef 呢?

试了半天都不行

Answer 1

这么复杂的sql 为什么要转呢？