Linq to SQL中报错"不允许在查询中显式构造实体类型"怎么解决

Question

from t in a1from tp in t.a2group t by t.Name into gselect new a1{ Name = g.Key, cc= g.Count() }a1为一个表,a1中有Name和cc字段,类型也一样.以上在.ToList()时报错... 我想在以上的语句后得到IQueryable<a1>,然后做后续处理再得到List<a1> 有高手能告诉我以上报错的原理和解决的方法吗?

Answer 1

from t in a1
from tp in t.a2
group t by t.Name into g
select new { Name = g.Key, cc= g.Count() }

用匿名对象。