private async Task<IReadOnlyList<CoreProduct>> GetCoreProducts(IEnumerable<IProductRequest> requests, int internalPropertyId)
        {
            var query = _dbContext.Products.OfType<CoreProduct>().AsSplitQuery();

            foreach(var request in requests.GroupBy(x => x.GetType(), x => x))
            {
                query = request switch
                {
                    IAccommodationRequest => AccommodationQuery(query),
                    // more types here
                    _ => throw new UnreachableException()
                };
            }

            return await query.Where(x => x.InternalPropertyId == internalPropertyId && requests.Select(x => x.ProductId).Contains(x.Id)).ToListAsync();
        }

        private IQueryable<CoreProduct> AccommodationQuery(IQueryable<CoreProduct> query)
            => query = query.OfType<InternalAccommodation>().Include(x => x.PriceDetails);

        private async Task<IReadOnlyList<CoreProduct>> GetCoreProducts(IEnumerable<IProductRequest> requests, int internalPropertyId)
        {
            var query = _dbContext.Products.OfType<CoreProduct>().AsSplitQuery();

            foreach(var request in requests.GroupBy(x => x.GetType(), x => x))
            {
                query = request switch
                {
                    IAccommodationRequest => AccommodationQuery(query),
                    // more types here
                    _ => throw new UnreachableException()
                };
            }

            return await query.Where(x => x.InternalPropertyId == internalPropertyId && requests.Select(x => x.ProductId).Contains(x.Id)).ToListAsync();
        }

        private IQueryable<CoreProduct> AccommodationQuery(IQueryable<CoreProduct> query)
            => query = query.OfType<InternalAccommodation>().Include(x => x.PriceDetails);

 private static List<int> FindOptimalUnits(LocalDate requestedStartDate, LocalDate requestedEndDate, int requestedQty, Dictionary<int, IPeriod[]> units)
        {
            var accommodationGapSize = new Dictionary<int, int>();


            foreach (var unit in units)
            {
                var currentClosestEndDate = LocalDate.MinIsoValue;
                var currentClosestStartDate = LocalDate.MaxIsoValue;

                foreach (var period in unit.Value)
                {
                    if (period.EndDate <= requestedStartDate && period.EndDate > currentClosestEndDate)
                    {
                        currentClosestEndDate = period.EndDate;
                    }

                    if (period.StartDate >= requestedEndDate && period.StartDate < currentClosestStartDate)
                    {
                        currentClosestStartDate = period.StartDate;
                    }

                    if (currentClosestEndDate == requestedStartDate && currentClosestStartDate == requestedEndDate)
                    {
                        break; // Cannot find a better 
                    }
                }

                var gapSize = Period.Between(currentClosestEndDate, currentClosestStartDate, PeriodUnits.Days).Days;
                accommodationGapSize.Add(unit.Key, gapSize);

            }


            foreach (var item in accommodationGapSize)
            {
                Console.WriteLine(item.Value);
            }
            return accommodationGapSize.OrderBy(x => x.Value).Take(requestedQty).Select(x => x.Key).ToList();
        }
    }

 private static List<int> FindOptimalUnits(LocalDate requestedStartDate, LocalDate requestedEndDate, int requestedQty, Dictionary<int, IPeriod[]> units)
        {
            var accommodationGapSize = new Dictionary<int, int>();


            foreach (var unit in units)
            {
                var currentClosestEndDate = LocalDate.MinIsoValue;
                var currentClosestStartDate = LocalDate.MaxIsoValue;

                foreach (var period in unit.Value)
                {
                    if (period.EndDate <= requestedStartDate && period.EndDate > currentClosestEndDate)
                    {
                        currentClosestEndDate = period.EndDate;
                    }

                    if (period.StartDate >= requestedEndDate && period.StartDate < currentClosestStartDate)
                    {
                        currentClosestStartDate = period.StartDate;
                    }

                    if (currentClosestEndDate == requestedStartDate && currentClosestStartDate == requestedEndDate)
                    {
                        break; // Cannot find a better 
                    }
                }

                var gapSize = Period.Between(currentClosestEndDate, currentClosestStartDate, PeriodUnits.Days).Days;
                accommodationGapSize.Add(unit.Key, gapSize);

            }


            foreach (var item in accommodationGapSize)
            {
                Console.WriteLine(item.Value);
            }
            return accommodationGapSize.OrderBy(x => x.Value).Take(requestedQty).Select(x => x.Key).ToList();
        }
    }

var composite = await _dbContext.Inventories.Where(i => requestedQuantity.Select(x => x.AccommodationId).Contains(i.AccommodationId) && nightsInterval.Contains(i.Date)) 
            && requestedQuantity.All(x => x.Value <= i.TotalQuantity - i.TotalReserved).ExecuteUpdateAsync(
            setters => setters.SetProperty(
               i => i.TotalReserved,
               i => i.TotalReserved + 1));

var composite = await _dbContext.Inventories.Where(i => requestedQuantity.Select(x => x.AccommodationId).Contains(i.AccommodationId) && nightsInterval.Contains(i.Date)) 
            && requestedQuantity.All(x => x.Value <= i.TotalQuantity - i.TotalReserved).ExecuteUpdateAsync(
            setters => setters.SetProperty(
               i => i.TotalReserved,
               i => i.TotalReserved + 1));

 escrow.ReleasedAt = _clock.Now();
        await _dbContext.SaveChangesAsync();

        var payoutToHostDetails = await _paymentGateway.PayoutToHost(escrow.CancelledAmount is not null ? (decimal)escrow.CancelledAmount : escrow.FullAmount,
                                                                     escrow.Id,
                                                                     escrow.Currency,
                                                                     host.StripeConnectAccountId!);

        if (!payoutToHostDetails.IsSuccess)
        {
            // Roll back the pending record if the transaction fails
            escrow.ReleasedAt = null;
            await _dbContext.SaveChangesAsync();

            return new BadRequestObjectResult(payoutToHostDetails.Error.Message);
        }

 escrow.ReleasedAt = _clock.Now();
        await _dbContext.SaveChangesAsync();

        var payoutToHostDetails = await _paymentGateway.PayoutToHost(escrow.CancelledAmount is not null ? (decimal)escrow.CancelledAmount : escrow.FullAmount,
                                                                     escrow.Id,
                                                                     escrow.Currency,
                                                                     host.StripeConnectAccountId!);

        if (!payoutToHostDetails.IsSuccess)
        {
            // Roll back the pending record if the transaction fails
            escrow.ReleasedAt = null;
            await _dbContext.SaveChangesAsync();

            return new BadRequestObjectResult(payoutToHostDetails.Error.Message);
        }

var listing = await _dbContext.Listings
     .AsSplitQuery()
     .Include(x => x.Accommodations).ThenInclude(x => x.Inventory)
     .FirstAsync(x => x.Id == request.ListingId && x.Host.UserId == currentUserId);

      var accommodations = listing.Accommodations... // just an example

var listing = await _dbContext.Listings
     .AsSplitQuery()
     .Include(x => x.Accommodations).ThenInclude(x => x.Inventory)
     .FirstAsync(x => x.Id == request.ListingId && x.Host.UserId == currentUserId);

      var accommodations = listing.Accommodations... // just an example