linq如何同时实现left join与right join?

[cicna]

我有三个表
User 用户表
UserOrg 用户组织关联表
Org 组织个
SQL语句是
select distinct * from User
left join UserOrg
on User.userid = UserOrg.userid
right join Org
on UserOrg.orgid = Org.orgid

Linq如何实现呢?

[q107770540]

var query=from o in Org
          join x in ( from u in User join uo in UserOrg
                 on u.userid equals uo.userid into lg
                 from uo in lg.DefaultIfEmpty()
                 select new {u,uo})
          on o.orgid equals x.orgid into lg2
          from x in lg2.DefaultIfEmpty()
          select o;

[cicna]

引用 1 楼 q107770540 的回复:

var query=from o in Org
          join x in ( from u in User join uo in UserOrg
                 on u.userid equals uo.userid into lg
                 from uo in lg.DefaultIfEmpty()
                 select new {u,uo})
          on o.orgid equals x.orgid into lg2
          from x in lg2.DefaultIfEmpty()
          select o;

好思路left join (left join)，按照这个做了果然行，谢谢版主。不过遇到了null值处理问题，详看http://bbs.csdn.net/topics/390667221