❔ Selecting child tables using EF Core

return await _dbContext.Enterprise
    .AsNoTracking()
    .Include(x => x.Companies)
        .ThenInclude(x => x.Sites)
        .ThenInclude(x => x.Departments)
        .ThenInclude(x => x.Containers)
    .SelectMany(x => x.Companies)
    .SelectMany(x => x.Sites)
    .SelectMany(x => x.Departments)
    .SelectMany(x => x.Containers)
    .FirstOrDefaultAsync(x => x.Id == id);