LINQ Select Distinct with Anonymous Types

by

Have a read through K. Scott Allen’s excellent post here:

And Equality for All … Anonymous Types

The short answer (and I quote):

Turns out the C# compiler overrides
Equals and GetHashCode for anonymous
types. The implementation of the two
overridden methods uses all the public
properties on the type to compute an
object’s hash code and test for
equality. If two objects of the same
anonymous type have all the same
values for their properties – the
objects are equal.

So it’s totally safe to use the Distinct() method on a query that returns anonymous types.

More Related Contents:

  1. LINQ’s Distinct() on a particular property
  2. Distinct by property of class with LINQ [duplicate]
  3. How to return anonymous type from c# method that uses LINQ to SQL [duplicate]
  4. Convert anonymous type to class
  5. linq distinct or group by multiple properties
  6. Get a list of distinct values in List
  7. How to use LINQ Distinct() with multiple fields
  8. A dictionary where value is an anonymous type in C#
  9. What is the best way to check two List lists for equality in C#
  10. Simultaneous equations in C# LINQ [closed]
  11. Lambda statement for finding sub-string in a string from list of strings [closed]
  12. Returning IEnumerable vs. IQueryable
  13. ‘Contains()’ workaround using Linq to Entities?
  14. Is a LINQ statement faster than a ‘foreach’ loop?
  15. What is “Best Practice” For Comparing Two Instances of a Reference Type?
  16. How to Count Duplicates in List with LINQ
  17. Accessing C# Anonymous Type Objects
  18. What is the effect of AsEnumerable() on a LINQ Entity?
  19. Query Microsoft Access MDB Database using LINQ and C#
  20. LINQ to find series of consecutive numbers
  21. Edit specific Element in XDocument
  22. Recursive LINQ query: select item and all children with subchildren
  23. Join and Include in Entity Framework
  24. Creating dynamic queries with entity framework
  25. The data source does not support server-side data paging
  26. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”
  27. How to group by DateTime.Date in EntityFramework
  28. How to include() nested child entity in linq
  29. LINQ query — Data aggregation (group adjacent)
  30. How do you unit test ASP.NET Core MVC Controllers that return anonymous objects?

Leave a Comment