/// <summary>
    /// Базовый класс накладной  с основными атрибутами
    /// </summary>
    public class BaseInvoice
    {

        /// <summary>
        /// Идентификатор накладной
        /// </summary>
        public Guid ID { get; set; }

        /// <summary>
        /// Номер накладной
        /// </summary>
        public int InvoiceNumber { get; set; }


        /// <summary>
        /// Дата создания накладной
        /// </summary>
        public DateTime CreationDate { get; set; }


        /// <summary>
        /// История напечатанных накладных
        /// </summary>
        public ICollection<Invoice> Invoices { get; set; }


        /// <summary>
        /// Идентификатор пользователя, совершившего операцию
        /// </summary>
        public string UserId { get; set; }

        public BaseInvoice()
        {
            Invoices = new List<Invoice>();
        }
    }

 /// <summary>
    /// Накладная на перемещение  товара
    /// </summary>
    public  class Invoice
    {
        /// <summary>
        /// Идентификатор накладной
        /// </summary>
        public Guid ID { get; set; }


        /// <summary>
        /// Склад-отправитель для накладной 
        /// </summary>
        public WareHouse Sender { get; set; }


        /// <summary>
        /// Склад-получатель для накладной 
        /// </summary>
        public WareHouse Receiver  { get; set; }


        /// <summary>
        /// Список товаров, отпущенной по накладной
        /// </summary>
        public ICollection<InvoiceCommodity> Commodities { get; set; }

        /// <summary>
        /// Базовая накладная
        /// </summary>
        public BaseInvoice BaseInvoice { get; set; }

        /// <summary>
        /// Дата создания накладной
        /// </summary>
        public DateTime CreationDate { get; set; }


        /// <summary>
        /// Идентификатор пользователя, совершившего операцию
        /// </summary>
        public string UserId { get; set; }
    }

   var printedInvoices =await mapplicationDbContext
                         .BaseInvoices
                         .AsNoTracking()
                          .Select(t => new PrintedInvoicesResponse
                          {
                              id = t.ID,
                              creationDate = t.Invoices.OrderBy(g => g.CreationDate).Last().CreationDate,
                              invoiceNumber = t.InvoiceNumber,                              
                              receiverWarehouseId=t.Invoices.OrderBy(g=>g.CreationDate).Last().Receiver.ID,
                              receiverWarehouseName = t.Invoices.OrderBy(g => g.CreationDate).Last().Receiver.Name,
                              senderWarehouseId= t.Invoices.OrderBy(g => g.CreationDate).Last().Sender.ID,
                              senderWarehouseName= t.Invoices.OrderBy(g => g.CreationDate).Last().Sender.Name
                          })
                         .ToListAsync();

SELECT [b].[ID] AS [id], (
    SELECT TOP(1) [i].[CreationDate]
    FROM [Invoices] AS [i]
    WHERE [b].[ID] = [i].[BaseInvoiceID]
    ORDER BY [i].[CreationDate] DESC) AS [creationDate], [b].[InvoiceNumber] AS [invoiceNumber], (
    SELECT TOP(1) [w].[ID]
    FROM [Invoices] AS [i0]
    LEFT JOIN [WareHouses] AS [w] ON [i0].[ReceiverID] = [w].[ID]
    WHERE [b].[ID] = [i0].[BaseInvoiceID]
    ORDER BY [i0].[CreationDate] DESC) AS [receiverWarehouseId], (
    SELECT TOP(1) [w0].[Name]
    FROM [Invoices] AS [i1]
    LEFT JOIN [WareHouses] AS [w0] ON [i1].[ReceiverID] = [w0].[ID]
    WHERE [b].[ID] = [i1].[BaseInvoiceID]
    ORDER BY [i1].[CreationDate] DESC) AS [receiverWarehouseName], (
    SELECT TOP(1) [w1].[ID]
    FROM [Invoices] AS [i2]
    LEFT JOIN [WareHouses] AS [w1] ON [i2].[SenderID] = [w1].[ID]
    WHERE [b].[ID] = [i2].[BaseInvoiceID]
    ORDER BY [i2].[CreationDate] DESC) AS [senderWarehouseId], (
    SELECT TOP(1) [w2].[Name]
    FROM [Invoices] AS [i3]
    LEFT JOIN [WareHouses] AS [w2] ON [i3].[SenderID] = [w2].[ID]
    WHERE [b].[ID] = [i3].[BaseInvoiceID]
    ORDER BY [i3].[CreationDate] DESC) AS [senderWarehouseName]
FROM [BaseInvoices] AS [b]

///linq
.select {
var invoice=t.Invoices.OrderBy(g=>g.CreationDate).Last();
receiverWarehouseId=invoice..Receiver.ID,
///аналогично
}