SQL转写为Linq

[sisiz]

select jiuyeren_shifou ,substring (jiuyedidian,0,4) , count(*) as jcount from KeJu_JiuYeJu_LuRuBiao WHERE JiuYeDiDian is not null group by jiuyeren_shifou,substring (jiuyedidian,0,4)
转写为Linq

[yangqidong]

var result= from jiuye in KeJu_JiuYeJu_LuRuBiao
          where jiuye.jiuyedidian != null
          group jiuye by new { jiuye.jiuyeren_shifou, jiuyedidianShort = jiuye.jiuyedidian.Substring(0, 4) } into g
          select new { g.Key.jiuyeren_shifou, g.Key.jiuyedidianShort, jiuyeCount = g.Count() };

[幸运的意外]

var
result= from jiuye in KeJu_JiuYeJu_LuRuBiao
where jiuye.jiuyedidian != null
group jiuye by new { jiuye.jiuyeren_shifou, jiuyedidianShort = jiuye.jiuyedidian.Substring(0, 4) } into g
select new { g.Key.jiuyeren_shifou, g.Key.jiuyedidianShort, jiuyeCount = g.Count() };