How to implement IEqualityComparer to return distinct values?

by

An EqualityComparer is not the way to go – it can only filter your result set in memory eg:

var objects = yourResults.ToEnumerable().Distinct(yourEqualityComparer);

You can use the GroupBy method to group by IDs and the First method to let your database only retrieve a unique entry per ID eg:

var objects = yourResults.GroupBy(o => o.Id).Select(g => g.First());

More Related Contents:

  1. Using Transactions or SaveChanges(false) and AcceptAllChanges()?
  2. Entity Framework async operation takes ten times as long to complete
  3. How to update record using Entity Framework 6?
  4. Serialization of Entity Framework objects with One to Many Relationship
  5. DbEntityValidationException – How can I easily tell what caused the error?
  6. Does Entity Framework Code First support stored procedures?
  7. Save and retrieve image (binary) from SQL Server using Entity Framework 6
  8. Setting unique Constraint with fluent API?
  9. Lazy Loading vs Eager Loading
  10. How to compare only date components from DateTime in EF?
  11. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  12. Entity Framework 6 Code First Custom Functions
  13. Entity Framework – stored procedure return value
  14. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  15. Problems using Entity Framework 6 and SQLite
  16. The remote server returned an unexpected response: (413) Request Entity Too Large.
  17. ef4 cause Circular reference in web service
  18. Linq Syntax – Selecting multiple columns
  19. Configure multiple database Entity Framework 6
  20. Log Queries executed by Entity Framework DbContext
  21. An error occurred while saving entities that do not expose foreign key properties for their relationships
  22. Entity Framework Code First Date field creation
  23. Entity Framework 4.1: Unable to cast from DbQuery to ObjectQuery
  24. Entity framework: StoreGeneratedPattern=”Computed” property
  25. Repository Pattern, POCO, and Business Entities
  26. How does the SQLite Entity Framework 6 provider handle Guids?
  27. System.Data.Entity.Core.EntityCommandExecutionException Occurred in MVC app Using EF
  28. How to set Identity Seed value in code-first?
  29. How to write this EF Mock setup code as a reusable Generic Boilerplate?
  30. .NET Managing Layers Relationships

Leave a Comment