Is it possible to do this ?

public partial class NorthwindDataContext { public static Func<NorthwindDataContext, int, IQueryable<Product>> ProductsByCategoryID = CompiledQuery.Compile ((NorthwindDataContext context, int categoryID) => context.Products.Where(p => p.CategoryID == categoryID));

public IQueryable<Product> GetProductsByCategoryIDFast(int                                                      categoryID)
{
    return ProductsByCategoryID(this, categoryID);
}

}

Hi there, could you please elaborate more? What for is all that?

We don't need compiled queries because our query producing pipeline is very quick (way below 1ms). MS uses compiled queries because their linq provider is often very slow (15-20ms for producing a query) in more complex queries, and the projection pipeline doesn't use projection code using generic classes but generated IL to perform the projection.