Linq query built in foreach loop always takes parameter value from last iteration

by

You’re reusing the same variable (key) in your lambda expression.

See my article on anonymous methods for more details, and there are a number of related SO questions too:

The simple fix is to copy the variable first:

List<string> keys = FillKeys()
foreach (string key in keys){
    string copy = key;
    q = q.Where(c => c.Company.Name.Contains(copy));
}

More Related Contents:

  1. Prevent duplicates from array, based on condition [closed]
  2. Where is likely the performance bug here? [closed]
  3. Combining two expressions (Expression)
  4. LINQ : Dynamic select
  5. What guarantees are there on the run-time complexity (Big-O) of LINQ methods?
  6. How to do a subquery in LINQ?
  7. Bulk-deleting in LINQ to Entities
  8. LINQ: Not Any vs All Don’t
  9. Linq select objects in list where exists IN (A,B,C)
  10. Could not find an implementation of the query pattern
  11. Does Distinct() method keep original ordering of sequence intact?
  12. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  13. ascending/descending in LINQ – can one change the order via parameter?
  14. How to select only the records with the highest date in LINQ
  15. Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported
  16. C# Linq intersect/except with one part of object
  17. MVC 4 how pass data correctly from controller to view
  18. Entity-framework code is slow when using Include() many times
  19. The operation cannot be completed because the DbContext has been disposed using MVC 4
  20. Linq to Objects – return pairs of numbers from list of numbers
  21. From Eric Lippert’s blog: “don’t close over the loop variable” [duplicate]
  22. Export Model to DataTable
  23. loading a full hierarchy from a self referencing table with EntityFramework.Core
  24. Update XML with C# using Linq
  25. Check if list contains item from other list in EntityFramework
  26. Add the where clause dynamically in Entity Framework
  27. Split a List into groups of consecutive numbers [closed]
  28. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  29. Select multiple fields group by and sum
  30. Linq – Top value from each group

Leave a Comment