EF Core中Include操作内用Select报错求助（通用仓储场景）

错误原因 #

EF Core 的 Include 方法仅接受直接导航属性访问的表达式（例如 t => t.MyNavigation 或 t => t.MyNavigation.SubNavigation），你传入的 a => a.Appointment.Finance.Select(fa => fa.FinanceCompany) 是投影操作，不符合 Include 的设计逻辑——Include 的作用是将关联实体加载到原实体的导航属性中，而非对数据进行投影筛选，因此触发了报错。

解决方案 #

方案1：修改通用仓储，支持嵌套导航加载（推荐）

微调仓储的 Get 方法，使其支持 ThenInclude 链式加载嵌套导航属性，这是 EF Core 加载多层关联实体的标准方式：

修改后的仓储方法：

using System;
using System.Linq;
using System.Linq.Expressions;
using Microsoft.EntityFrameworkCore;

public virtual IQueryable<T> Get(
    Expression<Func<T, bool>> filter = null,
    Func<IQueryable<T>, IOrderedQueryable<T>> orderBy = null,
    params Func<IQueryable<T>, IQueryable<T>>[] includes)
{
    IQueryable<T> query = _dbSet;

    if (filter != null)
    {
        query = query.Where(filter);
    }

    if (includes != null && includes.Any())
    {
        foreach (var include in includes)
        {
            query = include(query);
        }
    }

    if (orderBy != null)
    {
        return orderBy(query);
    }

    return query;
}

调用示例：

using System.Linq;
using Microsoft.EntityFrameworkCore;

private readonly GenericRepository<Appointment> _repository;
{
    var appointment = _repository.Get(
        // 过滤条件
        a => a.AppointmentId == appointmentId,
        // 排序规则
        null,
        // 关联加载配置
        q => q.Include(a => a.Purchases),
        q => q.Include(a => a.Employee),
        q => q.Include(a => a.Reviews),
        q => q.Include(a => a.Appointment.Finance).ThenInclude(fa => fa.FinanceCompany)
    )
    .FirstOrDefaultReadUncommitted();
}

方案2：使用投影查询（无需修改仓储）

如果无法调整仓储结构，可以直接在查询末尾使用投影操作，EF Core 会自动生成关联查询避免N+1问题：

using System.Linq;

private readonly GenericRepository<Appointment> _repository;
{
    var appointmentData = _repository.Get(
        a => a.AppointmentId == appointmentId,
        null
    )
    .Select(a => new {
        // 保留需要的Appointment核心字段
        AppointmentId = a.AppointmentId,
        Purchases = a.Purchases,
        Employee = a.Employee,
        Reviews = a.Reviews,
        // 直接投影嵌套关联数据
        FinanceCompanies = a.Appointment.Finance.Select(fa => fa.FinanceCompany)
    })
    .FirstOrDefaultReadUncommitted();
}

该方式返回匿名类型，若需要映射回实体类，可手动赋值或使用对象映射工具转换。

方案3：使用字符串路径的Include（兼容原有参数结构）

若必须保留原仓储的参数类型，可修改仓储方法支持字符串形式的导航路径（EF Core 允许通过字符串路径加载多层嵌套导航）：

修改后的仓储方法：

using System;
using System.Linq;
using System.Linq.Expressions;
using Microsoft.EntityFrameworkCore;

public virtual IQueryable<T> Get(
    Expression<Func<T, bool>> filter = null,
    Func<IQueryable<T>, IOrderedQueryable<T>> orderBy = null,
    params string[] includeProperties)
{
    IQueryable<T> query = _dbSet;

    if (filter != null)
    {
        query = query.Where(filter);
    }

    if (includeProperties != null && includeProperties.Any())
    {
        foreach (var includeProperty in includeProperties)
        {
            query = query.Include(includeProperty);
        }
    }

    if (orderBy != null)
    {
        return orderBy(query);
    }

    return query;
}

调用示例：

using System.Linq;

private readonly GenericRepository<Appointment> _repository;
{
    var appointment = _repository.Get(
        a => a.AppointmentId == appointmentId,
        null,
        "Purchases",
        "Employee",
        "Reviews",
        "Appointment.Finance.FinanceCompany"
    )
    .FirstOrDefaultReadUncommitted();
}

内容的提问来源于stack exchange，提问作者Dumitru Laurenţiu