Using the lambda Include method in a compiled LINQ query

Question

I'm currently trying to optimize some of the LINQ queries in my program by precompiling them. Some of these queries make extensive use of eager loading; here's an example of one:

public static Func<DatabaseEntities, string, IQueryable<Employee>> GetAllByName =
              CompiledQuery.Compile<DatabaseEntities, string, IQueryable<Employee>
              ((context, name) => context.Employees
                     .Include(e => e.Email)
                     .Where(e => e.LastName == name));

Example use:

var employees = GetAllByName(dbContext, "Bob").ToList();

Unfortunately, attempting to use this results in the following error:

LINQ to Entities does not recognize the method 'System.Linq.IQueryable[Employee] Include[Employee,Email] (System.Linq.IQueryable[Employee], System.Linq.Expressions.Expression[System.Func[Employee,Email]]) ' method, and this method cannot be translated into a store expression.

I've noticed that the normal method of eager loading (Include(string)) works fine within a precompiled query. Is there a way to use the lambda version as well?

one.beat.consumer · Accepted Answer · 2011-12-13 01:31:16Z

2

In short, no.

You cannot use the lambda within a precompiled linq statement/query.

answered Dec 13, 2011 at 1:31

one.beat.consumer

9,51413 gold badges57 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nguyễn Quốc Khánh · Accepted Answer · 2011-11-20 18:31:55Z

1

You can edit code precompile such as:

public static Func<DatabaseEntities, string, IQueryable<Employee>> GetAllByName =
              CompiledQuery.Compile<DatabaseEntities, string, IQueryable<Employee>
              ((context, name) => context.Employees
                     .Include("Email")
                     .Where(e => e.LastName == name));

answered Nov 20, 2011 at 18:31

Nguyễn Quốc Khánh

894 bronze badges

Collectives™ on Stack Overflow

Using the lambda Include method in a compiled LINQ query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related