日期:2014-05-20 浏览次数:21046 次
var works = 
           from a in A join b in B on a.aid equals b.aid into AB select new{a.enid, b.work}
           from ab in AB.DefaultIfEmpty() join c in C on c.enid equals ab.enid
           select new{workB = b.work, 
                      workC = c.work //?? 默认值 
           };
------解决方案--------------------
var query= from p in A
           join q in B
           on p.aid equals q.aid
           into temp
           from r in temp.DefaultIfEmpty()
           join s in C
           on q.enid equals s.enid
           into temp1
           from s in temp1.DefaultIfEmpty()
           select new 
           {
              q.work,
              r.work
           };