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如何轉(zhuǎn)成linq 或 linq to ef 呢?試了半天都不行
求助, SQL轉(zhuǎn)Linq
慕蓋茨4494581
2018-08-16 17:09:22
