Linq to sql 使用group by 统计多个字段,然后返回多个字段的值,话不多说,直接上例子:
var wflist = from u in db.TWelFare
where u.fy_no == fy_no
orderby u.we_no
group u by new { weno = u.we_no, wename = u.we_name } into g
select new { g.Key.weno, g.Key.wename };