请考虑以下两个查询及其结果:
var result = ent.tblCustomGroupBies
.GroupBy(a => groupA.Contains(a.Group.Value) ? "A" :
groupB.Contains(a.Group.Value) ? "B" :
"N/a")
.Select(a => new
{
KEY = a.Key,
VALUE = a.Count()
});
并且其结果显示在GridView
中:
第二个查询:
var result3 = from p in ent.tblCustomGroupBies
group p by new { Criterion = groupA.Contains(p.Group.Value) ? "A" :
groupB.Contains(p.Group.Value) ? "B" :
"N/a" }
into g
select new { KEY = g.Key, VALUE = g.Count() };
并且它的结果在 GridView
中显示如下:
为什么第一个查询中的 Select(a => new)
显示键列,但 select new
却没有显示?