首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > .NET >

Linq左联接+多条件

2012-08-24 
Linq左连接+多条件select p.Id,r.Id,s.Id,s.Name,p.Title,p.TotalScore from JHExamPaper as epinner join

Linq左连接+多条件
select p.Id,r.Id,s.Id,s.Name,p.Title,p.TotalScore from JHExamPaper as ep
inner join Paper as p on ep.PaperId=p.Id
inner join Subject as s on p.SubjectId=s.Id
left join ExamPaperStudent as eps on ep.PaperId=eps.PaperId and eps.ExamId='B39A5BEE-8021-4A0D-8CC2-4BDEFC580579' and UserId='110813D3-AF1D-41A2-9F39-B44604CA2BC6'
left join Report as r on eps.Id=r.EPSId

如何把上面的SQL转化成Linq,求大神指教,在线等。

[解决办法]

C# code
var query=from ep in JHExamPaper          join p in Paper on ep.PaperId equals p.Id          join s in Subject on p.SubjectId equals s.Id          join eps in ExamPaperStudent on ep.PaperId equals eps.PaperId into leftJoinGroup          from eps in leftJoinGrou.DefaultIfEmpty()          join r in Report on eps.Id equlas r.EPSId into Left          from r in Left.DefalutIfEmpty()          where eps.ExamId=="B39A5BEE-8021-4A0D-8CC2-4BDEFC580579" && eps.UserId=="110813D3-AF1D-41A2-9F39-B44604CA2BC6"          select new           {            p.Id,r.Id,s.Id,s.Name,p.Title,p.TotalScore           }; 

热点排行