求助, SQL转Linq

Question

SELECTc.id,c.CustomersName as name,f.FollowUpTheWay as names,f.NextFollowDate,f.FollowDate,f.id as fidfrom 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 为什么要转呢？