学步园

内链接inner join

示例如下：

var query = from tb0 in db.table_0
                        join tb1 in db.table_1 on table_0.关联键 equals table_1.关联键
                        select new { ... };

左链接或右链接，使用DefaultIfEmpty()语法，采用些语法前需要用到into语法

示例如下：
 var  query2 = from tb0 in db.table_0
                    join tb1 in db.table_1  on table_0.关联键 equals table_1.关联键
                    into all
                    from tb2 in all.DefaultIfEmpty()
                    select new { ... };