EF通用仓储模式下特定仓储无法访问表达式属性问题

问题概述 #

使用GenericRepository模式操作EF数据库多年，其他仓储均能在表达式中正常访问对应实体的属性，但唯独LocationRecord相关仓储在调用FirstOrDefaultAsync时，无法通过x.唤起实体属性的智能提示，无法访问实体属性。

通用仓储实现 #

GenericRepository.cs #

public class GenericRepository<TEntity> : IGenericRepository<TEntity> where TEntity : class
{
    private readonly DbContext _context;

    public DbSet<TEntity> DbSet() => _context.Set<TEntity>();

    public async Task<TEntity> FirstOrDefaultAsync(Expression<Func<TEntity, bool>> func, CancellationToken cancellationToken) =>
        await DbSet().FirstOrDefaultAsync(func, cancellationToken).ConfigureAwait(false);
}

IGenericRepository接口 #

public interface IGenericRepository<TEntity> where TEntity : class
{
    Task<TEntity> FirstOrDefaultAsync(Expression<Func<TEntity, bool>> func, CancellationToken cancellationToken);
}

正常工作的Account仓储实现 #

public class AccountRepository : GenericRepository<Account>, IAccountRepository
{
    public AccountRepository(DiscountedDbContext context) : base(context)
    { }
}

public interface IAccountRepository : IGenericRepository<Account>
{
}

// 调用示例
public class AccountManagementService
{
    private readonly IAccountRepository _accountRepository;

    public AccountManagementService(IAccountRepository accountRepository)
    {
        _accountRepository = accountRepository;
    }

    public async Task<Account> GetAccountAsync(int id, CancellationToken cancellationToken)
    {
        // 此处可正常访问Account的属性
        Account account = await _accountRepository.FirstOrDefaultAsync(x => x.Id == 1, cancellationToken);
        return account;
    }
}

异常的LocationRecord仓储实现 #

public class LocationRecordRepository : GenericRepository<LocationRecord>, ILocationRecordRepository
{
    public LocationRecordRepository(DiscountedDbContext context) : base(context)
    {
    }
}

public interface ILocationRecordRepository : IGenericRepository<LocationRecord>
{
}

// 调用示例（存在接口不匹配问题）
public class GeoLocationService
{
    private readonly ILocationRepository _locationRepository; // 注意：此处注入的接口名与定义的ILocationRecordRepository不匹配

    public GeoLocationService(ILocationRepository locationRepository)
    {
        _locationRepository = locationRepository;
    }

    public async Task<LocationRecord> GetCurrentLocationAsync(CancellationToken cancellationToken)
    {
        // 问题：无法显示LocationRecord的属性
        LocationRecord current = await _locationRepository.FirstOrDefaultAsync(x => x., cancellationToken);
        return current;
    }
}

实体模型定义 #

public class Account
{
    public int Id { get; set; }
    public string? Email { get; set; }
    public string? Name { get; set; }
    public string? Surname { get; set; }
    public string? Password { get; set; }
    public Guid StoreCode { get; set; }
}

public class LocationRecord
{
    public int Id { get; set; }
    public DateTime? DateRecorded { get; set; }
    public string Country { get; set; } = null!;
    public string District { get; set; } = null!;
    public string Town { get; set; } = null!;
    public string PostCode { get; set; } = null!;
    public int Count { get; set; } = 0;
}

排查与解决方向 #

• 修正接口注入不匹配问题：GeoLocationService构造函数中注入的是ILocationRepository，但实际定义的仓储接口是ILocationRecordRepository，这会导致编译器无法识别泛型参数为LocationRecord，直接修改注入的接口类型为ILocationRecordRepository即可解决智能提示问题。
• 确认实体映射配置：检查DiscountedDbContext中是否包含public DbSet<LocationRecord> LocationRecords { get; set; }的定义，或者是否通过Fluent API正确配置了该实体的映射关系。
• 清理并重新编译项目：编译器缓存可能导致智能提示异常，清理项目的bin、obj目录后重新生成解决方案。
• 检查命名空间引用：确认LocationRecord实体、仓储接口及实现类的命名空间是否一致，确保项目中已正确引用相关程序集。

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