LINQ: Distinct values

by

Are you trying to be distinct by more than one field? If so, just use an anonymous type and the Distinct operator and it should be okay:

var query = doc.Elements("whatever")
               .Select(element => new {
                             id = (int) element.Attribute("id"),
                             category = (int) element.Attribute("cat") })
               .Distinct();

If you’re trying to get a distinct set of values of a “larger” type, but only looking at some subset of properties for the distinctness aspect, you probably want DistinctBy as implemented in MoreLINQ in DistinctBy.cs:

 public static IEnumerable<TSource> DistinctBy<TSource, TKey>(
     this IEnumerable<TSource> source,
     Func<TSource, TKey> keySelector,
     IEqualityComparer<TKey> comparer)
 {
     HashSet<TKey> knownKeys = new HashSet<TKey>(comparer);
     foreach (TSource element in source)
     {
         if (knownKeys.Add(keySelector(element)))
         {
             yield return element;
         }
     }
 }

(If you pass in null as the comparer, it will use the default comparer for the key type.)

More Related Contents:

  1. Entity framework linq query Include() multiple children entities
  2. How can I do an OrderBy with a dynamic string parameter?
  3. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  4. How to view LINQ Generated SQL statements?
  5. LINQ across multiple databases
  6. Convert String to Int in EF 4.0
  7. LINQ Select Distinct with Anonymous Types
  8. System.LINQ.Dynamic: Select(” new (…)”) into a List (or any other enumerable collection of )
  9. LINQ Join with Multiple Conditions in On Clause
  10. Standard Deviation in LINQ
  11. How To Project a Line Number Into Linq Query Results
  12. Calculate difference from previous item with LINQ
  13. LINQ with SQLite (linqtosql)
  14. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  15. How to create a dynamic LINQ join extension method
  16. EF 4: Removing child object from collection does not delete it – why?
  17. linq distinct or group by multiple properties
  18. How to dynamically add OR operator to WHERE clause in LINQ
  19. Get a list of distinct values in List
  20. How to use LINQ Distinct() with multiple fields
  21. Greater Than Condition in Linq Join
  22. How do I write this cross apply query in LINQ-to-SQL?
  23. Can’t make GroupJoin work. NavigationExpandingExpressionVisitor exception
  24. LINQ Include vs Join. Are they equivalent?
  25. Tradeoffs using NHibernate 3.0 QueryOver or LINQ provider
  26. If condition in LINQ Where clause
  27. Point connectionstring in dbml to app.config
  28. How to implement Unit of Work that works with EF and NHibernate
  29. Building Dynamic LINQ Queries based on Combobox Value
  30. NHibernate vs LINQ to SQL

Leave a Comment