ABP 4.4.4下EF5多对多查询触发Queryable转Enumerable方法错误求助

问题根因 #

EF Core 5.x 不支持在查询投影的内部直接执行ToList()这类立即枚举集合的方法，你在拼接ContactWithNavigationProperties对象时，对join生成的分组集合直接调用了ToList()，EF无法将该操作翻译为SQL语句，因此抛出转换异常。

解决方案 #

方案1：使用导航属性加载（推荐）

你已经配置了多对多导航属性，无需手写全部join逻辑，直接通过Include/ThenInclude预加载关联数据即可，写法更简洁且符合EF规范：

protected virtual async Task<IQueryable<ContactWithNavigationProperties>> GetQueryForNavigationPropertiesAsync()
{
    return (await GetDbSetAsync())
        .Include(c => c.Department)
        .Include(c => c.Client)
        .Include(c => c.ContactAddresses).ThenInclude(ca => ca.Address)
        .Include(c => c.ContactEmailAddresses).ThenInclude(cea => cea.EmailAddress)
        .Include(c => c.ContactPhoneNumbers).ThenInclude(cpn => cpn.PhoneNumber)
        .Select(contact => new ContactWithNavigationProperties
        {
            Contact = contact,
            Department = contact.Department,
            Client = contact.Client,
            Addresses = contact.ContactAddresses.Select(ca => ca.Address).ToList(),
            EmailAddresses = contact.ContactEmailAddresses.Select(cea => cea.EmailAddress).ToList(),
            PhoneNumbers = contact.ContactPhoneNumbers.Select(cpn => cpn.PhoneNumber).ToList()
        });
}

方案2：拆分查询逻辑

如果必须保留手写join的写法，将查询拆分为两步：先拉取所有关联的扁平结果到内存，再分组组装目标对象：

// 第一步：查询扁平关联数据到内存
var rawData = await (from contact in await GetDbSetAsync()
           join department in dbContext.Departments
             on contact.DepartmentId equals department.Id into departments
           from department in departments.DefaultIfEmpty()
           join client in dbContext.Clients
             on contact.ClientId equals client.Id into clients
           from client in clients.DefaultIfEmpty()
           join contactAddress in dbContext.Set<ContactAddress>()
             on contact.Id equals contactAddress.ContactId into contactAddresses
           from contactAddress in contactAddresses.DefaultIfEmpty()
           join address in dbContext.Addresses
             on contactAddress.AddressId equals address.Id into addresses
           from address in addresses.DefaultIfEmpty()
           // 省略Email、Phone的join逻辑，和Address写法一致
           select new 
           {
               contact,
               department,
               client,
               address
               // 补充email、phone字段
           }).ToListAsync();

// 第二步：内存分组组装目标对象
return rawData.GroupBy(x => x.contact.Id)
    .Select(g => new ContactWithNavigationProperties
    {
        Contact = g.First().contact,
        Department = g.First().department,
        Client = g.First().client,
        Addresses = g.Select(x => x.address).Distinct().ToList(),
        // 补充Email、Phone集合赋值
    }).AsQueryable();

注意事项 #

• 你使用的ABP 4.4.4版本绑定了EF Core 5.x，不要随意跨大版本升级EF Core，避免出现框架兼容问题。
• ABP框架内置了导航属性预加载的扩展方法，你也可以直接使用IncludeDetails()封装方法简化加载逻辑。

内容的提问来源于stack exchange，提问作者jlavallet