关于ling to sql左右连接的问题

关键字： into ...  from....in

例子：

左链接：

 var udept = (from a in entities.UserDepartment
                            join b in entities.User on a.UserId equals b.UserId
                            into temp
                            from x in temp.DefaultIfEmpty()
                            select x);

以entities.UserDepartment为主表关联entities.User

右连接同左连接，只需把entities.UserDepartment和entities.User 对调即可