Lambda连接查询获取两个表中任意的字段

//Lambda 

      var List = List1.GroupJoin(List2, x => x.Emp_no, y => y.c25, (x, y) => y.Select(z =>    //x,y是条件

                         new MKR008_acture_worker   //用来装以下字段的表

                         {

                             Emp_no = x.Emp_no,

                             Name = x.Name,

                             Line = x.Line,

                             Floor_name = x.Floor_name,

                             Paragraph = x.Paragraph,

                             Duty = z.duty,

                             Dept_name = z.depname

                         })).SelectMany(x => x).ToList();