I’m migrating a .NET Framework project to .NET 8 which uses Entity Framework for data access.

Using EF 6, I pass my include statements into my repository as an expression, something like this:

Expression<Func<Company, object>>[] getCompaniesIncludeExpressions =
{
    e => e.Categories.Select(c => c.Projects.Select(d => d.Jobs.Select(f => f.Location))),
    e => e.CompanyUsers
}; 

and attach to the content as follows:

public async Task<List<TEntity>> SelectAllAsync(Expression<Func<TEntity, object>>[] includeExpressions, Expression<Func<TEntity, bool>> whereExpression)
{
    var entities = Context.Set<TEntity>().AsQueryable();

    if (includeExpressions != null)
    {
        foreach (var includeExpression in includeExpressions)
        {
            entities = entities.Include(includeExpression);
        }
    }

    if (whereExpression == null) return await entities.ToListAsync();

    var list = await entities
        .Where(whereExpression).ToListAsync();

    return list;
}

I get the following exception with the above in EF Core:

AggregateException: One or more errors occurred. (The expression ‘e.Categories.AsQueryable().Select(c => c.Projects.AsQueryable().Select(d => d.Jobs.AsQueryable().Select(f => f.Location)))’ is invalid inside an ‘Include’ operation, since it does not represent a property access: ‘t => t.MyProperty’. To target navigations declared on derived types, use casting (‘t => ((Derived)t).MyProperty’) or the ‘as’ operator (‘t => (t as Derived).MyProperty’). Collection navigation access can be filtered by composing Where, OrderBy(Descending), ThenBy(Descending), Skip or Take operations.

How would I refactor this to pass in the expression and include child properties using ThenInclude?

Thanks in advance