求教!如何将以下SQL语句转成Linq
如何将以下SQL语句转成Linq :select [EMP_PROJECT].*,MILESTONE.MILESTONE_DATE2 from [EMP_PROJECT] left join
(
select [PROJECT_ID],max([MILESTONE_DATE2]) as [MILESTONE_DATE2] from [EMP_MILESTONE]
group by [PROJECT_ID]
) MILESTONE on [EMP_PROJECT].UUID=MILESTONE.PROJECT_ID
where [EMP_PROJECT].PRINT_TIME>MILESTONE.MILESTONE_DATE2 --------------------编程问答--------------------
var query= from ep in [EMP_PROJECT]
join mt in [EMP_MILESTONE].GroupBy(x=>x.PROJECT_ID).Select(g=>new {g.Key,MILESTONE_DATE2=g.Max(x=>x.MILESTONE_DATE2)})
on ep.UUID equals mt.PROJECT_ID into lfGroup
from mt in lfGroup.DefaultIfEmpty()
where ep.PRINT_TIME>mt.MILESTONE_DATE2
select new {ep,MILESTONE_DATE2=mt==null?0:mt.MILESTONE_DATE2};
建议你下次自己先写写,此类SQL没什么难度
补充:.NET技术 , LINQ