联表查询
new DBHelper<DTStudentModel>()
.Select(p => new
{
p.IdentityID,
p.StuCode,
p.StuName,
p.StuAge,
p.StuSex
})
.Select<DTScoreModel>(p => p.Score)
.Join<DTStudentModel, DTScoreModel>(DBJoinType.Left, (k, v) => k.StuCode == v.StuCode)
.OrderBy(p => p.IdentityID)
.ToEntityList<DTStudentModel>();
-- 对应 SQL
select [T_Student].[IdentityID],[T_Student].[StuCode],[T_Student].[StuName],[T_Student].[StuAge],[T_Student].[StuSex],[T_Score].[Score] from [T_Student] left join [T_Score] on ([T_Student].[StuCode] = [T_Score].[StuCode]) order by [T_Student].[IdentityID] asc