Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

LINQ expressions. Variable 'p' of type referenced from scope, but it is not defined

Tags:

I'm building a LINQ query dynamically with this code. It seems to work, but when i have more than one searchString in my search, (so when multiple expressions are added, i get the following error:

Variable 'p' of type referenced from scope, but it is not defined**

I guess i can only define /use p once. But, if so, i need to alter my code a bit. Can anyone point me in the right direction here?

    if (searchStrings != null)     {         foreach (string searchString in searchStrings)         {             Expression<Func<Product, bool>> containsExpression = p => p.Name.Contains(searchString);             filterExpressions.Add(containsExpression);         }     }      Func<Expression, Expression, BinaryExpression>[] operators = new Func<Expression, Expression, BinaryExpression>[] { Expression.AndAlso };     Expression<Func<Product, bool>> filters = this.CombinePredicates<Product>(filterExpressions, operators);      IQueryable<Product> query = cachedProductList.AsQueryable().Where(filters);      query.Take(itemLimit).ToList();  << **error when the query executes**       public Expression<Func<T, bool>> CombinePredicates<T>(IList<Expression<Func<T, bool>>> predicateExpressions, Func<Expression, Expression, BinaryExpression> logicalFunction)     {         Expression<Func<T, bool>> filter = null;          if (predicateExpressions.Count > 0)         {             Expression<Func<T, bool>> firstPredicate = predicateExpressions[0];             Expression body = firstPredicate.Body;             for (int i = 1; i < predicateExpressions.Count; i++)             {                 body = logicalFunction(body, predicateExpressions[i].Body);             }             filter = Expression.Lambda<Func<T, bool>>(body, firstPredicate.Parameters);         }          return filter;     } 
like image 765
Tys Avatar asked Mar 23 '13 16:03

Tys


1 Answers

Simplifying, here are several lines which you are trying to do (I use string instead Product etc, but idea is the same):

        Expression<Func<string, bool>> c1 = x => x.Contains("111");         Expression<Func<string, bool>> c2 = y => y.Contains("222");         var sum = Expression.AndAlso(c1.Body, c2.Body);         var sumExpr = Expression.Lambda(sum, c1.Parameters);         sumExpr.Compile(); // exception here 

Please notice how I expanded your foreach into two expressions with x and y - this is exactly how it looks like for compiler, that are different parameters.

In other words, you are trying to do something like this:

x => x.Contains("...") && y.Contains("..."); 

and compiler wondering what is that 'y' variable??

To fix it, we need to use exactly the same parameter (not just name, but also reference) for all expressions. We can fix this simplified code like this:

        Expression<Func<string, bool>> c1 = x => x.Contains("111");         Expression<Func<string, bool>> c2 = y => y.Contains("222");         var sum = Expression.AndAlso(c1.Body, Expression.Invoke(c2, c1.Parameters[0])); // here is the magic         var sumExpr = Expression.Lambda(sum, c1.Parameters);         sumExpr.Compile(); //ok 

So, fixing you original code would be like:

internal static class Program {     public class Product     {         public string Name;     }      private static void Main(string[] args)     {         var searchStrings = new[] { "111", "222" };         var cachedProductList = new List<Product>         {             new Product{Name = "111 should not match"},             new Product{Name = "222 should not match"},             new Product{Name = "111 222 should match"},         };          var filterExpressions = new List<Expression<Func<Product, bool>>>();         foreach (string searchString in searchStrings)         {             Expression<Func<Product, bool>> containsExpression = x => x.Name.Contains(searchString); // NOT GOOD             filterExpressions.Add(containsExpression);         }          var filters = CombinePredicates<Product>(filterExpressions, Expression.AndAlso);          var query = cachedProductList.AsQueryable().Where(filters);          var list = query.Take(10).ToList();         foreach (var product in list)         {             Console.WriteLine(product.Name);         }     }      public static Expression<Func<T, bool>> CombinePredicates<T>(IList<Expression<Func<T, bool>>> predicateExpressions, Func<Expression, Expression, BinaryExpression> logicalFunction)     {         Expression<Func<T, bool>> filter = null;          if (predicateExpressions.Count > 0)         {             var firstPredicate = predicateExpressions[0];             Expression body = firstPredicate.Body;             for (int i = 1; i < predicateExpressions.Count; i++)             {                 body = logicalFunction(body, Expression.Invoke(predicateExpressions[i], firstPredicate.Parameters));             }             filter = Expression.Lambda<Func<T, bool>>(body, firstPredicate.Parameters);         }          return filter;     } } 

But notice the output:

222 should not match 111 222 should match 

Not something you may expect.. This is result of using searchString in foreach, which should be rewritten in the following way:

        ...         foreach (string searchString in searchStrings)         {             var name = searchString;             Expression<Func<Product, bool>> containsExpression = x => x.Name.Contains(name);             filterExpressions.Add(containsExpression);         }         ... 

And here is output:

111 222 should match 
like image 94
Lanorkin Avatar answered Sep 19 '22 18:09

Lanorkin