LINQ查询拼接字符串触发表达式树错误，求解决方案

EF Core会将LINQ查询转换为表达式树再生成SQL，但string.Format的可变参数（params）形式无法被EF Core正确解析，且其内部涉及的部分类型属于ref struct，表达式树不支持这类操作，因此触发报错。

方案一：先加载数据到内存，再处理字符串拼接 #

将实体数据从数据库拉取到内存后，再进行地址拼接操作，避开表达式树的限制，同时优化空值处理逻辑：

public async Task<InvoiceLocationDTO> GetLocationDetails(int locId)
{
    try
    {
        // 先加载完整实体到内存，确保关联数据被Include
        var loc = await context.Location
            .Where(loc => loc.Id == locId)
            .Include(x => x.LocationAddress)
            .Include(x => x.LocationAddress.State)
            .FirstOrDefaultAsync();

        if (loc == null)
            return null;

        // 收集非空的地址片段
        var addressParts = new[]
        {
            loc.LocationAddress.Address,
            loc.LocationAddress.AddressExtraLine,
            loc.LocationAddress.City,
            loc.LocationAddress.State?.Name,
            loc.LocationAddress.Zip
        }
        .Where(part => !string.IsNullOrWhiteSpace(part))
        .ToArray();

        // 用Join拼接，自动避免多余逗号
        return new InvoiceLocationDTO
        {
            BillToAddress = string.Join(", ", addressParts)
        };
    }
    catch (Exception ex)
    {
        throw ex;
    }
}

方案二：数据库层面拼接（适合需SQL端处理的场景） #

通过EF Core支持的简单字符串拼接语法，将逻辑转换为SQL执行，最后处理可能的末尾逗号：

public async Task<InvoiceLocationDTO> GetLocationDetails(int locId)
{
    try
    {
        var locationDetails = await (
            from loc in context.Location.Where(loc => loc.Id == locId)
            .Include(x => x.LocationAddress)
            .Include(x => x.LocationAddress.State)
            select new InvoiceLocationDTO
            {
                BillToAddress = 
                    (!string.IsNullOrEmpty(loc.LocationAddress.Address) ? loc.LocationAddress.Address + ", " : "") +
                    (!string.IsNullOrEmpty(loc.LocationAddress.AddressExtraLine) ? loc.LocationAddress.AddressExtraLine + ", " : "") +
                    (!string.IsNullOrEmpty(loc.LocationAddress.City) ? loc.LocationAddress.City + ", " : "") +
                    (!string.IsNullOrEmpty(loc.LocationAddress.State?.Name) ? loc.LocationAddress.State.Name + ", " : "") +
                    (!string.IsNullOrEmpty(loc.LocationAddress.Zip) ? loc.LocationAddress.Zip : "")
            }
        ).FirstOrDefaultAsync();

        // 移除末尾可能存在的", "
        if (locationDetails?.BillToAddress != null && locationDetails.BillToAddress.EndsWith(", "))
        {
            locationDetails.BillToAddress = locationDetails.BillToAddress[..^2];
        }

        return locationDetails;
    }
    catch (Exception ex)
    {
        throw ex;
    }
}

• 必须通过Include加载LocationAddress和State关联数据，避免懒加载导致的空引用或额外数据库查询
• 空值处理很重要，可避免生成包含多余逗号的无效地址字符串

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