Intersect LINQ query

by

Yes.

As other people have answered, you can use Where, but it will be extremely inefficient for large sets.

If performance is a concern, you can call Join:

var results = original.Join(idsToFind, o => o.Id, id => id, (o, id) => o);

If idsToFind can contain duplicates, you’ll need to either call Distinct() on the IDs or on the results or replace Join with GroupJoin (The parameters to GroupJoin would be the same).

More Related Contents:

  1. Get all checked nodes of a treeview
  2. How to use LINQ to select object with minimum or maximum property value
  3. How to flatten tree via LINQ?
  4. When to use .First and when to use .FirstOrDefault with LINQ?
  5. Using LINQ to remove elements from a List
  6. Update all objects in a collection using LINQ
  7. Convert string[] to int[] in one line of code using LINQ
  8. LINQ – Left Join, Group By, and Count
  9. Extension methods must be defined in a non-generic static class
  10. LINQ Aggregate algorithm explained
  11. Func with out parameter
  12. LINQ Grouping dynamically
  13. Why does Enumerable.All return true for an empty sequence? [duplicate]
  14. C# – code to order by a property using the property name as a string [duplicate]
  15. Can I specify my explicit type comparator inline?
  16. LINQ Inner-Join vs Left-Join
  17. LINQ Where Ignore Accentuation and Case
  18. DISTINCT() and ORDERBY issue
  19. Can I split an IEnumerable into two by a boolean criteria without two queries?
  20. Can I LINQ a JSON?
  21. Find substring in a list of strings
  22. Get List element position in c# using LINQ
  23. Linq style “For Each” [duplicate]
  24. Remove Item in Dictionary based on Value
  25. How to sort a dictionary by key
  26. How does PredicateBuilder work
  27. Issues Doing a String Comparison in LINQ
  28. C# Searching for files and folders except in certain folders
  29. Linq where column == (null reference) not the same as column == null
  30. Does “foreach” cause repeated Linq execution?

Leave a Comment