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

求Ling写法,多表,该如何处理

2012-05-30 
求Ling写法,多表select * from A left join B on A.xB.x and A.yB.yC# codevar a (from R in Resultjo

求Ling写法,多表
select * from A left join B on A.x=B.x and A.y=B.y


C# code
            var a = (from R in Result                     join T in SuccessionGradeChains on R.GradeCode equals T.GradeCode into os                      from TT in os.DefaultIfEmpty()                     select new{                         R.GradeCode,                         R.DisciplineCode,                         SuccessorGradeNo = (TT == null ? null : TT.SuccessorGradeNo)                     });


在on后面也要加一条件,现在无从下手
试and无效

[解决办法]
C# code
 var a = (from R in Result                     join T in SuccessionGradeChains on new{GradeCode = R.GradeCode,GradeName=R.GradeName} equals new{ GradeCode =T.GradeCode,GradeName=T.GradeName} into os                      from TT in os.DefaultIfEmpty()                     select new{                         R.GradeCode,                         R.DisciplineCode,                         SuccessorGradeNo = (TT == null ? null : TT.SuccessorGradeNo)                     }); 

热点排行