Include in a compiled query

Question

I'm trying to identify and improve some hotspots in a WCF-service. One of the queries uses an awful lot of Include statements. SQL server performance is sunshine and lollipops, but EF performance is really bad.

Breaking this monster down into several smaller queries has already helped a lot, converting some of the queries to CompiledQueries also did wonders for the overall execution time.

Sadly EF seems to lack the possibility to properly handle an Include statement in a CompiledQuery, throwing an exception saying:

LINQ to Entities does not recognize the method 'System.Linq.IQueryable`1[xx] Include[xxx](System.Linq.IQueryable`1[xxx], System.String)' method, and this method cannot be translated into a store expression.

The compiled query simply looks like this:

        private static readonly Func<OurContext, Guid, IQueryable<MyType>> GetResidenceAccessForSubscriber =
        CompiledQuery.Compile<OurContext, Guid, IQueryable<MyType>>(
        (context, value) => (
            from t in context.MyType.Include("Stuff.MoarStuff")
            where t.Id == value
            select t));

While the original looks like (and works):

var q = (
                        from tin container.MyType
                        where t.Id == id
                        select t)
                            .Include("Stuff.MoarStuff");

Any tips?