C# How Combine Some Linq Expression In a Loop

Question

i want to combine some Linq Expression, so i help from below articles:

http://www.c-sharpcorner.com/uploadfile/04fe4a/predicate-combinators-in-linq/ and http://thanhhh.blogspot.com/2011/10/linq-to-entities-predicatebuilder-and.html

and i have a generic list like this:

List<long> lstPA = new List<long>() { 2, 3 }; // the numbers can be added or removed

if i use under code for combine my linq expression, i get correct results(records) from db (i use Entity Framework 4.0):

var exp1 = Predicate.FalseExpression<posts>();            
exp1 = exp1.Or(x => x.post_author == 2);
exp1 = exp1.Or(x => x.post_author == 3);

but when i combine linq expression in a foreach loop Like this:

var exp1 = Predicate.FalseExpression<posts>();
foreach (long id in lstPA)
{
    exp1 = exp1.Or(x => x.post_author == id);
}

i can't get correct result(records) from db.

what is diffrence between 2 code blocks and how can solve this problem (i must use foreach loop)?

you could do something with .Where(x => lstPA.Contains(x.post_author)) for what is quite likely a much faster approach. — slippyr4, Jul 25 '14 at 11:19

score 7 · Accepted Answer · answered Jul 25 '14 at 11:22

I believe your issue is to do with closure. The variable id is assigned to the expression and it updates to a newer value each time you loop. In order to use it you want to make an individually scoped variable.

var exp1 = Predicate.FalseExpression<posts>();
foreach (long i in lstPA)
{
    long id = i;
    exp1 = exp1.Or(x => x.post_author == id);
}

However you could just use the contains clause instead in this instance.

expr1 = x => lstPA.Contains(x.post_author);

score 2 · Answer 2 · edited May 23 '17 at 12:11

2

Looks like an instance of the foreach closure problem. You are passing two times the same ID to the database. Apply the fix described in the linked question: Copy id to a variable inside of the loop.

edited May 23 '17 at 12:11

Community

1
1

answered Jul 25 '14 at 11:21

usr

168,620
35
240
369

score 1 · Answer 3 · answered Jul 25 '14 at 11:28

this appears to me to be an issue with closures and loops. Id references the loop variable and will continue to do so, which means it changes and reads something like

exp1 = exp1.Or(x => x.post_author == 3);
exp1 = exp1.Or(x => x.post_author == 3);

when unfolded. To fix that you could try:

var exp1 = Predicate.FalseExpression<posts>();
foreach (long id in lstPA)
{
  long tempID = id;
  exp1 = exp1.Or(x => x.post_author == tempID);
}

this makes sure a temporary variable that was created in the loop and never changed afterwards gets used instead of the loop variable which is mutated during its course.

C# How Combine Some Linq Expression In a Loop

3 Answers3