Check if list contains item from other list in EntityFramework

by

I’ll suggest:

var searchIds = new List<int>{1,2,3,4,5};
var result = persons.Where(p => p.Locations.Any(l => searchIds.Contains(l.Id)));

Contains will be translated to IN statement.

Keep in mind that the id list goes into the sql statement. If your id list is huge then you’ll end up having a huge query.

More Related Contents:

  1. Bulk-deleting in LINQ to Entities
  2. Linq: help me to make this work
  3. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  4. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  5. The type of one of the expressions in the join clause is incorrect in Entity Framework
  6. Entity framework left join
  7. LEFT JOIN in LINQ to entities?
  8. Linq to EntityFramework DateTime
  9. LINQ to SQL multiple tables left outer join
  10. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  11. How to compare only date components from DateTime in EF?
  12. How to Bulk Update records in Entity Framework?
  13. The result of a query cannot be enumerated more than once
  14. Entity Framework 6 Code First Custom Functions
  15. Entity Framework. Delete all rows in table
  16. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  17. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  18. Order by dynamic parameter
  19. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  20. Linq Syntax – Selecting multiple columns
  21. Linq to Entity Join table with multiple OR conditions
  22. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  23. Log Queries executed by Entity Framework DbContext
  24. Simulating Cross Context Joins–LINQ/C#
  25. Entity Framework core – Contains is case sensitive or case insensitive?
  26. How to do an “in” query in entity framework?
  27. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  28. How to include() nested child entity in linq
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. LINQ Query to Convert string to datetime

Leave a Comment