Linq之路--左关联

C# LINQ 左关联详解

最新推荐文章于 2025-07-15 14:23:01 发布

转载最新推荐文章于 2025-07-15 14:23:01 发布 · 321 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/xuhp/p/10502848.html

 1 var list = (from left in paramlist
 2             join right in paramissuelist  
 3             on new{ EQUIPMENT_CODE=left.EQUIPMENT_CODE
 4 ,STEP_CODE= left.STEP_CODE} 
 5             equals new { EQUIPMENT_CODE = right.EQUIPMENT_CODE
 6 ,STEP_CODE = right.STEP_CODE}
 7             into JoinedEmpDept from right in JoinedEmpDept.DefaultIfEmpty()
 8         select new
 9                  {
10                      SETTING_VALUE = left.SETTING_VALUE,
11                      ONLINE_ADDRESS = right != null ? right.ONLINE_ADDRESS : null,
12                      EQUIPMENT_CODE =left.EQUIPMENT_CODE,
13                      STEP_CODE= left.STEP_CODE,
14                      STEP_NAME=left.STEP_NAME,
15                      PARAM_NAME=left.PARAM_NAME
16                   }).ToList();

多条件左关联

 1 var list = (from left in paramlist
 2             join right in paramissuelist  
 3             on left.EQUIPMENT_CODE equals new right.EQUIPMENT_CODE
 4             into JoinedEmpDept from right in JoinedEmpDept.DefaultIfEmpty()
 5         select new
 6                  {
 7                      SETTING_VALUE = left.SETTING_VALUE,
 8                      ONLINE_ADDRESS = right != null ? right.ONLINE_ADDRESS : null,
 9                      EQUIPMENT_CODE =left.EQUIPMENT_CODE,
10                      STEP_CODE= left.STEP_CODE,
11                      STEP_NAME=left.STEP_NAME,
12                      PARAM_NAME=left.PARAM_NAME
13                   }).ToList();