.Invoke expression in Entity Framework?

Question

Entity Framework does not support the Expression.Invoke statement. When you try to use it, you get the following exception:

"LINQ node expression of type" Invoke "is not supported in LINQ to Entities.

Does anyone have a workaround for this missing functionality? I would like to use the detailed PredicateBuilder here in the context of the Entity Framework.

Edit 1 @marxidad - I like your suggestion, however it confuses me somewhat. Can you give additional recommendations on the proposed solution?

Edit 2 @marxidad - Thanks for the clarification.

Answer 1

PredicateBuilder and LINQKit now support Entity Framework.

Sorry guys for not doing this before!

Answer 2

I posted the solution here

Answer 3

Yes, it seems that the Entity Framework does not support this, and I could not use jerry-rig to make it evaluate how it works.

Answer 4

The Entity structure transforms LINQ expressions into Entity command trees, and only canonical functions are supported inside them. You will need to use command trees with canonical functions to do something like PredicateBuilder.

Answer 5

Phobis solution is on the money.

With little effort, you can create complex Dynamic LINQ queries on the fly using this approach