EF Core中Include引用NotMapped属性触发InvalidOperationException错误求助

在.NET 7与Entity Framework Core 7.0.2开发场景下，定义Account实体类时为Customer属性添加了[NotMapped]特性，调用Include(t => t.Customer)尝试关联查询包含Customer数据时，触发System.InvalidOperationException，错误提示该表达式不是有效的属性访问。

实体代码 #

public class Account
{
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    [Key]
    public Guid Id { get; set; } = Guid.NewGuid();

    [ForeignKey("Customer")]
    public Guid CustomerId { get; set; }

    [NotMapped]
    public Customer Customer { get; set; }

    [Required]
    public string Name { get; set; } = string.Empty;

    [Required]
    public string Password { get; set; } = string.Empty;

    [Required]
    public Boolean Active { get; set; } = true;
}

查询代码 #

public async Task<List<Account>> GetAll()
{
    List<Account> result = await db.Account.Include(t => t.Customer).AsNoTracking().ToListAsync();
    return result;
}

错误堆栈 #

System.InvalidOperationException: The expression 't.Customer' is invalid inside an 'Include' operation, since it does not represent a property access: 't => t.MyProperty'. To target navigations declared on derived types, use casting ('t => ((Derived)t).MyProperty') or the 'as' operator ('t => (t as Derived).MyProperty'). Collection navigation access can be filtered by composing Where, OrderBy(Descending), ThenBy(Descending), Skip or Take operations. For more information on including related data, see http://go.microsoft.com/fwlink/?LinkID=746393.
   at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.PopulateIncludeTree(IncludeTreeNode includeTreeNode, Expression expression, Boolean setLoaded)
   at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.<PopulateIncludeTree>g__TryExtractIncludeTreeNode|65_0(Expression innerExpression, String propertyName, IncludeTreeNode& addedNode, <>c__DisplayClass65_0&)
   at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.PopulateIncludeTree(IncludeTreeNode includeTreeNode, Expression expression, Boolean setLoaded)
   at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.ProcessInclude(NavigationExpansionExpression source, Expression expression, Boolean thenInclude, Boolean setLoaded)
   at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)
   at Microsoft.EntityFrameworkCore.Query.Internal.NavigationExpandingExpressionVisitor.Expand(Expression query)
   at Microsoft.EntityFrameworkCore.Query.QueryTranslationPreprocessor.Process(Expression query)
   at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query)
   at Microsoft.EntityFrameworkCore.Storage.Database.CompileQuery[TResult](Expression query, Boolean async)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass12_0`1.<ExecuteAsync>b__0()
   at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func`1 compiler)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteAsync[TResult](Expression query, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.ExecuteAsync[TResult](Expression expression, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1.GetAsyncEnumerator(CancellationToken cancellationToken)
   at System.Runtime.CompilerServices.ConfiguredCancelableAsyncEnumerable`1.GetAsyncEnumerator()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource]

解决方案 #

方案1：移除[NotMapped]特性（推荐，适用于需要EF Core自动关联查询的场景） #

[NotMapped]特性会告知EF Core该属性不映射到数据库表字段，不属于EF Core的导航属性范畴，因此Include方法无法识别并处理它。如果需要通过Include实现关联查询，必须移除该特性，让EF Core将其视为合法的导航属性：

public class Account
{
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    [Key]
    public Guid Id { get; set; } = Guid.NewGuid();

    [ForeignKey("Customer")]
    public Guid CustomerId { get; set; }

    // 移除[NotMapped]特性
    public Customer Customer { get; set; }

    [Required]
    public string Name { get; set; } = string.Empty;

    [Required]
    public string Password { get; set; } = string.Empty;

    [Required]
    public Boolean Active { get; set; } = true;
}

同时需确保：

• Customer实体已正确定义主键（如public Guid Id { get; set; }）
• DbContext中已注册DbSet<Customer>

方案2：手动加载关联数据（适用于必须保留[NotMapped]的场景） #

如果业务上要求Customer属性不映射到数据库，无法通过Include自动加载，可先查询所有Account，再批量查询对应的Customer并手动赋值：

public async Task<List<Account>> GetAll()
{
    // 先查询所有账户
    var accounts = await db.Account.AsNoTracking().ToListAsync();
    // 提取所有需要的客户ID
    var customerIds = accounts.Select(a => a.CustomerId).Distinct().ToList();
    // 批量查询客户数据
    var customers = await db.Customer.Where(c => customerIds.Contains(c.Id)).AsNoTracking().ToListAsync();
    
    // 手动关联赋值
    foreach (var account in accounts)
    {
        account.Customer = customers.FirstOrDefault(c => c.Id == account.CustomerId);
    }
    
    return accounts;
}

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