0

Jon Skeet has a good answer (LINQ Between Operator) about how to write an expression tree which will run in LINQ to SQL to perform a between operation. Ive tried this with EF but it fails due to the Invoke call below being unsupported.

    public static Expression<Func<TSource, bool>> Between<TSource, TKey>(Expression<Func<TSource, TKey>> keySelector, TKey low, TKey high) where TKey : IComparable<TKey>
    {
        Expression key = Expression.Invoke(keySelector, keySelector.Parameters.ToArray());

The LINQ expression node type 'Invoke' is not supported in LINQ to Entities.

Is there an alternative to Invoke which can be used here to get the property specified by the input lambda so this works with EF?

Community
  • 1
  • 1
undefined
  • 33,537
  • 22
  • 129
  • 198
  • check whether this helps..http://stackoverflow.com/questions/5284912/the-linq-expression-node-type-invoke-is-not-supported-in-linq-to-entities – Saravanan Jan 21 '15 at 05:33
  • @Saravanan I think its a different issue, he is dealing specifically with a passed in lambda which isn't expressionised, this question relates specifically to building an expression tree. – undefined Jan 26 '15 at 20:19
  • Have a look at [LINQKit](http://www.albahari.com/nutshell/linqkit.aspx), it can rewrite the expression to remove the `Invoke()`, so that EF can understand it. – svick Feb 17 '15 at 15:54

0 Answers0