LINQ: Select where object does not contain items from list

by

In general, you’re looking for the “Except” extension.

var rejectStatus = GenerateRejectStatuses();
var fullList = GenerateFullList();
var rejectList = fullList.Where(i => rejectStatus.Contains(i.Status));
var filteredList = fullList.Except(rejectList);

In this example, GenerateRegectStatuses() should be the list of statuses you wish to reject (or in more concrete terms based on your example, a List<int> of IDs)

More Related Contents:

  1. Get All instead of FirstOrDefault
  2. How to write this nested foreach loop query in LINQ?
  3. Group by in LINQ
  4. Linq: GroupBy, Sum and Count
  5. Find an item in a list by LINQ
  6. Reading a file line by line in C#
  7. ToList()– does it create a new list?
  8. Combination of List
  9. The ‘:’ character, hexadecimal value 0x3A, cannot be included in a name
  10. LINQ Select Distinct with Anonymous Types
  11. LINQ Orderby Descending Query
  12. Check if two lists are equal
  13. How to get the closest number from a List with LINQ?
  14. LINQ aggregate and group by periods of time
  15. Convert string to int array using LINQ [duplicate]
  16. Cannot use a lambda expression as an argument to a dynamically dispatched operation without first casting it to a delegate or expression tree type
  17. How set value a property selector Expression
  18. LINQ: Using INNER JOIN, Group and SUM
  19. linq distinct or group by multiple properties
  20. How do I perform Date Comparison in EF query?
  21. Filtering include items in LINQ and Entity Framework [duplicate]
  22. Should I use two “where” clauses or “&&” in my LINQ query?
  23. Max or Default?
  24. Get a list of distinct values in List
  25. Performance of Find() vs. FirstOrDefault() [duplicate]
  26. How to check for nulls in a deep lambda expression? [duplicate]
  27. What does LINQ return when the results are empty
  28. Update records using LINQ
  29. Last and LastOrDefault not supported
  30. Accessing System Databases/Tables using LINQ to SQL?

Leave a Comment