在 LINQ to Entities 查询中无法构造实体或复杂类型

public List<CustomerType> GetCustomerTypesBySchemaTypeCode(int schemaTypeCode)
        {
            var query = (from a in _reportTypeRepository.TableNoTracking.Where(v => v.SchemaType == schemaTypeCode)
                        group a by new { a.CustomerTypeId, a.SchemaType } into g
                        select new CustomerType
                        {
                            Id = g.Key.CustomerTypeId,
                            Name=""
                           // Name=_customerTypeRepository.GetById(g.Key.CustomerTypeId).Name
                        }).ToList();

            return query;
        }

public List<CustomerType> GetCustomerTypesBySchemaTypeCode(int schemaTypeCode)
        {
            var query = (from a in _reportTypeRepository.TableNoTracking.Where(v => v.SchemaType == schemaTypeCode)
                         group a by new { a.CustomerTypeId, a.SchemaType } into g
                         select g).ToList().Select(v =>
                          new CustomerType
                        {
                            Id = v.Key.CustomerTypeId,
                            Name = ""
                            // Name=_customerTypeRepository.GetById(g.Key.CustomerTypeId).Name
                        }).ToList();

            return query;
        }

原理： linq 选择数据时候 不能new 已知的对象，只能匿名的。 但是如果从一个 List 列表 就可以new 已知的类。

转载于:https://www.cnblogs.com/miralce/p/5067195.html