在尝试使用 LINQ to Entities 查询时遇到了一个NotSupportedException，原因是尝试将Int32转换为Decimal的方法未被识别。为解决此问题，需要先将数据转换为List，然后进行GroupBy操作。
var sectionBasin = (from s in section
join b in standard
on s.SectionCode equals b.SectionCode
select new
{
SectionCode = s.SectionCode,
Province = s.Province,
Standard = b.Standard
}) .GroupBy(x => x.Province).Select(t => new
{
code = t.Key,
upStd = t.Where(x => x.Standard == 0).Count(),
subStd = t.Where(x => x.Standard == 1).Count(),
join b in standard
on s.SectionCode equals b.SectionCode
select new
{
SectionCode = s.SectionCode,
Province = s.Province,
Standard = b.Standard
}) .GroupBy(x => x.Province).Select(t => new
{
code = t.Key,
upStd = t.Where(x => x.Standard == 0).Count(),
subStd = t.Where(x => x.Standard == 1).Count(),
最低0.47元/天 解锁文章
扫一扫
1130
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
