Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to use an Expression<Func<Model, bool>> in a Linq to EF where condition?

There have already been some questions about this topic (for instance Expression.Invoke in Entity Framework?), however, I could not find an answer for my specific situation. I would like to define a method like this:

public IQueryable<Customer> GetCustomers(Expression<Func<Customer, bool>> condition)
{
    return from p in ctx.Customers.AsExpandable()
        where condition.Compile()(p)
        select p;
}

The AsExpandable method is from LinqKit (as it was adviced in the thread mentioned before). However, when I try to call my method like his:

var customers = GetCustomers(c => c.ID == 1);

It throws an InvalidCastException:

Unable to cast object of type 'System.Linq.Expressions.InstanceMethodCallExpressionN' to type 'System.Linq.Expressions.LambdaExpression'. What am I doing wrong?

like image 405
Mark Vincze Avatar asked Oct 17 '11 15:10

Mark Vincze


1 Answers

If you want to use an expression tree, you need to pass the expression tree itself to the LINQ method:

return ctx.Customers.AsExpandable().Where(condition)
like image 138
SLaks Avatar answered Oct 17 '22 00:10

SLaks