如何从C# Expression<Func>中获取关联表Name列的值

以下是相关代码定义：

实体模型 #

public partial class SalesPipelineEntryClosedInformation : FoxHireEntityBase
{
    [Key]
    public int Id { get; set; }
    public string ClosedDetails { get; set; }
    public bool Won { get; set; }
    public int? TypeCompetitorId { get; set; }
    public int? TypeLostReasonId { get; set; }
    public int? TypeDeclineReasonId { get; set; }

    [ForeignKey(nameof(TypeCompetitorId))]
    [InverseProperty(nameof(TypeCompetitor.SalesPipelineEntryClosedInformations))]
    public virtual TypeCompetitor Competitor { get => Get(_competitor); set => _competitor = value; }
    
    [ForeignKey(nameof(TypeLostReasonId))]
    [InverseProperty(nameof(TypeLostReason.SalesPipelineEntryClosedInformations))]
    public virtual TypeLostReason LostReason { get => Get(_lostReason); set => _lostReason = value; }

    [ForeignKey(nameof(TypeDeclineReasonId))]
    [InverseProperty(nameof(TypeDeclineReason.SalesPipelineEntryClosedInformations))]
    public virtual TypeDeclineReason DeclineReason { get => Get(_declineReason); set => _declineReason = value; }
}

统计计算方法 #

private async Task CalculateStats(InsightType insightType)
{
    if (insightType.Value == InsightType.Competitor.Value)
    {
        await processStatsList(x => x.TypeCompetitorId.HasValue, x => x.Competitor.Name, new List<string> {"Competitor"}, InsightType.Competitor);
    }
    else if (insightType.Value == InsightType.IndustryReason)
    {
        await processStatsList(x => x.TypeDeclineReasonId.HasValue, x => x.DeclineReason.Name, new List<string> {"DeclineReason"}, InsightType.IndustryReason);
    }
    else if (insightType.Value == InsightType.LostReason)
    {
        await processStatsList(x => x.TypeLostReasonId.HasValue, x => x.LostReason.Name, new List<string> {"LostReason"}, InsightType.LostReason);
    }
}

原统计处理方法（存在问题） #

private async Task processStatsList(Expression<Func<SalesPipelineEntryClosedInformation, bool>> whereClause, 
                                    Expression<Func<SalesPipelineEntryClosedInformation, string>> relatedTableNameValue, 
                                    List<string> includes, InsightType insightType)
{
    await clearRecordTypes(insightType.Value);
    var closedInfo = await _genericRepository.GetList(whereClause, includes);

    var stats = closedInfo.Select(x => new
        {
            x.TypePipelineDealTypeId,
            relatedTableNameValue.Value // 此处无法正确获取Name值
        }).GroupBy(x => new {x.Name})
        .Select(x => new SalesInsightStat
        {
            Count = x.Count(),
            Name = x.Key.Name,
            InsightTypeId = insightType.Value
        }).ToList();

    await _genericRepository.AddRangeAsync(stats);
} 

问题分析 #

relatedTableNameValue是一个Expression<Func<...>>表达式树，不能直接通过.Value访问执行结果。同时原代码中匿名类型未明确命名属性，会导致后续GroupBy时x.Name无法识别。

解决方案 #

修改processStatsList方法，核心改动点：

1. 将表达式编译为Func委托，用于从实体中提取Name值
2. 在匿名类型中明确命名属性为Name，确保GroupBy能正确引用
3. 确保includes参数已正确加载对应的关联实体，避免懒加载导致的空引用

修改后的代码：

private async Task processStatsList(Expression<Func<SalesPipelineEntryClosedInformation, bool>> whereClause, 
                                    Expression<Func<SalesPipelineEntryClosedInformation, string>> relatedTableNameValue, 
                                    List<string> includes, InsightType insightType)
{
    await clearRecordTypes(insightType.Value);
    var closedInfo = await _genericRepository.GetList(whereClause, includes);
    
    // 将表达式编译为可执行的委托
    var getNameDelegate = relatedTableNameValue.Compile();

    var stats = closedInfo.Select(x => new
        {
            x.TypePipelineDealTypeId,
            // 通过委托获取关联实体的Name值，并明确属性名
            Name = getNameDelegate(x)
        })
        .GroupBy(x => x.Name)
        .Select(x => new SalesInsightStat
        {
            Count = x.Count(),
            Name = x.Key,
            InsightTypeId = insightType.Value
        }).ToList();

    await _genericRepository.AddRangeAsync(stats);
} 

关键说明 #

• relatedTableNameValue.Compile()将表达式树转换为可以直接调用的Func委托，此时closedInfo已经是加载到内存中的实体集合，使用委托不会影响EF的查询逻辑。
• 匿名类型中显式定义Name属性，确保后续GroupBy和统计时能正确引用该字段。
• 提前通过includes加载关联实体，避免调用委托时触发EF懒加载，提升性能并防止空引用异常。

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