_dbContext.Units
.Select(x => new
{
UnitId = x.UnitId,
Name = x.Name
})
.Include(p => p.Shops)
.ThenInclude(p => p.Department)
.ThenInclude(p => p.Products.Where(i => i.Availability == available))
.AsNoTracking()
.SingleOrDefaultAsync(p => p.UnitId == unitId);
_dbContext.Units
.Select(x => new
{
UnitId = x.UnitId,
Name = x.Name
})
.Include(p => p.Shops)
.ThenInclude(p => p.Department)
.ThenInclude(p => p.Products.Where(i => i.Availability == available))
.AsNoTracking()
.SingleOrDefaultAsync(p => p.UnitId == unitId);