Join on联合查询
join后面跟所要连接的集合,on后面跟的是连接条件。
var res = from m in masterList
join s in skillList on m.Age equals s.WorkAge
select new{master = m, skill = s};
var res = from m in masterList
join s in skillList on m.Age equals s.WorkAge
where s.ID > 15
select new{master = m, skill = s};