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

Question

from t in a1
from tp in t.a2
group t by t.Name into g
select new a1{ Name = g.Key, cc= g.Count() }
a1为一个表,a1中有Name和cc字段,类型也一样.

以上在.ToList()时报错...

 

我想在以上的语句后得到IQueryable<a1>,然后做后续处理再得到List<a1>

 

有高手能告诉我以上报错的原理和解决的方法吗?

Answer 1

from t in a1from tp in t.a2group t by t.Name into gselect new { Name = g.Key, cc= g.Count() }用匿名对象。