Entity Framework Core 将列映射到对象

问：

我有一个表示查询的字符串。查询非常复杂，涉及多个联接。这是我选择的：

SELECT 
    [SO].Id, [SO].SerialNumber, [SO].EstimateId,
    CASE
        WHEN [SO].EstimateId IS NOT NULL 
            THEN (SELECT TOP(1) [EST].[SerialNumber]
                  FROM [Estimates] AS [EST]
                  WHERE ([EST].[OrganizationId] = 1) 
                    AND ([EST].[EstimateId] = [SO].[EstimateId]))
            ELSE NULL
    END, 
    [SO].RecCreateTs, [SO].EstimatedDeliveryDate, [SO].Status, 
    [SO].PriceTotal, [SO].InRevision, [CST].CompanyName, 
    [CON].FirstName, [CON].LastName, [SOR].FirstName, [SOR].LastName, 
    [SOR].EstimatedDeliveryDate, [SOR].PriceTotal

有些列是相同的，但它们来自不同的表。

我试图映射 Select 中的属性：

var salesOrders = _context.SalesOrders.FromSqlRaw(sqlString)
    .Select(so => new SalesOrder
    {
        Id = so.Id,
        SerialNumber = so.SerialNumber,
        EstimateId = so.EstimateId,
        // the property below is [NotMapped]
        EstimateSerialNumber = so.EstimateId != null ? _context.Estimates.AsNoTracking().FirstOrDefault(w => w.OrganizationId == organizationId && w.EstimateId == so.EstimateId).SerialNumber : null,
        RecCreateTs = so.RecCreateTs,
        EstimatedDeliveryDate = so.EstimatedDeliveryDate,
        Status = so.Status,
        PriceTotal = so.PriceTotal,
        InRevision = so.InRevision,
        Customer = new Customer { CompanyName = so.Customer.CompanyName },
        CustomerContact = new CustomerContact { FirstName = so.CustomerContact.FirstName, LastName = so.CustomerContact.LastName },
        SalesOrderRevisions = so.InRevision
        ? new List<SalesOrderRevision>
        {
            so.SalesOrderRevisions.OrderByDescending(x => x.Id).Select(soRevision => new SalesOrderRevision
            {
                CustomerContact = new CustomerContact { FirstName = soRevision.CustomerContact.FirstName, LastName = soRevision.CustomerContact.LastName },
                EstimatedDeliveryDate = soRevision.EstimatedDeliveryDate,
                PriceTotal = soRevision.PriceTotal
            }).FirstOrDefault()
        }
        : null
    })
    .ToList();

但它没有用。如何告诉 EF Core 如何将每一列与相应的对象属性相关联？