How to do an “in” query in entity framework?

by

Try this:

var orderKeys = new int[] { 1, 12, 306, 284, 50047};
var orders = (from order in context.Orders 
              where orderKeys.Contains(order.Key);
              select order).ToList();
Assert.AreEqual(orderKeys.Count, orders.Count);

Edit: I have found some workarounds for this issue – please see WHERE IN clause?:

The Entity Framework does not
currently support collection-valued
parameters (‘statusesToFind’ in your
example). To work around this
restriction, you can manually
construct an expression given a
sequence of values using the following
utility method:

More Related Contents:

  1. Linq: help me to make this work
  2. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  3. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  4. Entity Framework/Linq EXpression converting from string to int
  5. Filter/Search using Multiple Fields – ASP.NET MVC
  6. How to convert an expression tree to a partial SQL query?
  7. Join and Include in Entity Framework
  8. Max return value if empty query
  9. Remove item from list based on condition
  10. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  11. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  12. How to include() nested child entity in linq
  13. Should the order of LINQ query clauses affect Entity Framework performance?
  14. LINQ Query to Convert string to datetime
  15. How to write this nested foreach loop query in LINQ?
  16. Linq: GroupBy, Sum and Count
  17. ‘Contains()’ workaround using Linq to Entities?
  18. How can I automatically filter out soft deleted entities with Entity Framework?
  19. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  20. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  21. Entity Framework – Cannot convert lambda expression to type ‘string’ because it is not a delegate type
  22. Internal .NET Framework Data Provider error 1025
  23. How to filter data using Entity Framework in a way that DataGridView be editable and context track changes?
  24. Filtering include items in LINQ and Entity Framework [duplicate]
  25. Max or Default?
  26. How do I do a left outer join with Dynamic Linq?
  27. LINQ performance FAQ
  28. Last and LastOrDefault not supported
  29. How to group by DateTime.Date in EntityFramework
  30. Repository Pattern, POCO, and Business Entities

Leave a Comment