How would you do a “not in” query with LINQ?

by

You want the Except operator.

var answer = list1.Except(list2);

Better explanation here: https://docs.microsoft.com/archive/blogs/charlie/linq-farm-more-on-set-operators

NOTE: This technique works best for primitive types only, since you have to implement an IEqualityComparer to use the Except method with complex types.

More Related Contents:

  1. How to read lines to dictionary with linQ [closed]
  2. Difference Between Select and SelectMany
  3. Distinct by property of class with LINQ [duplicate]
  4. Quickest way to compare two generic lists for differences
  5. Convert string[] to int[] in one line of code using LINQ
  6. LINQ – Left Join, Group By, and Count
  7. When should I dispose of a data context
  8. How do I use LINQ Contains(string[]) instead of Contains(string)
  9. Sequence contains no elements?
  10. Func with out parameter
  11. Determine if a sequence contains all elements of another sequence using Linq [duplicate]
  12. LINQ Ring: Any() vs Contains() for Huge Collections
  13. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  14. Linq to EntityFramework DateTime
  15. LINQ to SQL multiple tables left outer join
  16. how to check if object already exists in a list
  17. How to Bulk Update records in Entity Framework?
  18. LINQ Inner-Join vs Left-Join
  19. Find character with most occurrences in string?
  20. Get table-data from table-name in LINQ DataContext
  21. Is it Linq or Lambda?
  22. Local variable and expression trees
  23. convert this LINQ expression into Lambda
  24. List complex sorting
  25. How to sort a dictionary by key
  26. LINQ performance Count vs Where and Count
  27. Issues Doing a String Comparison in LINQ
  28. Linq access property by variable
  29. LINQ Query to Convert string to datetime
  30. Convert DataTable to Generic List in C#

Leave a Comment