Accepted answer

your concern about size of the query and size of the result set are tangible.

as @brokenglass mentioned ef doesn't allow you doing filtering or ordering on includes. if you want to order or filter relations you must use projection either to anonymous type or custom (non mapped) type:

        var query = db.leagues
                      .where(l => l.urlpart.equals(leaguename))
                      .select(l => new 
                              league = l,
                              events = l.leagueevents.where(...)
                                                     .select(e => e.event)


unfortunately ef doesn't allow to selectively load related entities using its navigation properties, it will always load all foos if you specify include("foo").

you will have to do a join on each of the related entities using your where() clauses as filters where they apply.

Related Query