GroupBy on complex object (e.g. List)

by

To get objects to work with many of LINQ’s operators, such as GroupBy or Distinct, you must either implement GetHashCode & Equals, or you must provide a custom comparer.

In your case, with a property as a list you probably need a comparer, unless you made the list read only.

Try this comparer:

public class SampleObjectComparer : IEqualityComparer<SampleObject>
{
    public bool Equals(SampleObject x, SampleObject y)
    {
        return x.Id == y.Id && x.Events.SequenceEqual(y.Events);
    }

    public int GetHashCode(SampleObject x)
    {
        return x.Id.GetHashCode() ^ x.Events.Aggregate(0, (a, y) => a ^ y.GetHashCode());
    }
}

Now this code works:

    var items = new List<SampleObject>()
    {
        new SampleObject() { Id = "Id", Events = new List<string>() { "ExampleEvent"} },
        new SampleObject() { Id = "Id", Events = new List<string>() { "ExampleEvent" } }
    };

    var comparer = new SampleObjectComparer();

    var duplicates = items.GroupBy(x => x, comparer)
                     .Where(g => g.Count() > 1)
                     .Select(g => g.Key)
                     .ToList();

More Related Contents:

  1. LINQ query — Data aggregation (group adjacent)
  2. Remove duplicates in the list using linq
  3. Is there a good LINQ way to do a cartesian product?
  4. Sort a list from another list IDs
  5. How to get index using LINQ? [duplicate]
  6. Using Linq to group a list of objects into a new grouped list of list of objects
  7. LINQ Contains Case Insensitive
  8. Lambda/Linq with Contains criteria for multiple keywords
  9. Entity Framework/Linq EXpression converting from string to int
  10. Differences between IQueryable, List, IEnumerator?
  11. JContainer, JObject, JToken and Linq confusion
  12. How do you perform a CROSS JOIN with LINQ to SQL?
  13. Why can’t I call an extension method from a base class of the extended type‏?
  14. Difference between Lookup() and Dictionary(Of list())
  15. Enumerating through an object’s properties (string) in C#
  16. Is the Linq Count() faster or slower than List.Count or Array.Length?
  17. Return list using select new in LINQ
  18. Intersect LINQ query
  19. LINQ – Query syntax vs method chains & lambda [closed]
  20. How to get first record in each group using Linq
  21. String.IsNullOrWhiteSpace in LINQ Expression
  22. How to Quickly Remove Items From a List
  23. How to use LINQ Distinct() with multiple fields
  24. LINQ query to return a Dictionary
  25. LINQ: Select where object does not contain items from list
  26. How/Can I use linq to xml to query huge xml files with reasonable memory consumption?
  27. Select multiple fields group by and sum
  28. Where can I find the System.Linq.Dynamic dll?
  29. Linq – Top value from each group
  30. C# generics compared to C++ templates [duplicate]

Leave a Comment