How to use LINQ Distinct() with multiple fields

by

I assume that you use distinct like a method call on a list. You need to use the result of the query as datasource for your DropDownList, for example by materializing it via ToList.

var distinctCategories = product
                        .Select(m => new {m.CategoryId, m.CategoryName})
                        .Distinct()
                        .ToList();
DropDownList1.DataSource     = distinctCategories;
DropDownList1.DataTextField  = "CategoryName";
DropDownList1.DataValueField = "CategoryId";

Another way if you need the real objects instead of the anonymous type with only few properties is to use GroupBy with an anonymous type:

List<Product> distinctProductList = product
    .GroupBy(m => new {m.CategoryId, m.CategoryName})
    .Select(group => group.First())  // instead of First you can also apply your logic here what you want to take, for example an OrderBy
    .ToList();

A third option is to use MoreLinq’s DistinctBy.

More Related Contents:

  1. LINQ’s Distinct() on a particular property
  2. Distinct by property of class with LINQ [duplicate]
  3. LINQ Select Distinct with Anonymous Types
  4. linq distinct or group by multiple properties
  5. Get a list of distinct values in List
  6. Read a CSV to a C# object to be able to do LINQ query on it [closed]
  7. Convert Linq expression “obj => obj.Prop” into “parent => parent.obj.Prop”
  8. C# Linq Group By on multiple columns [duplicate]
  9. How would you do a “not in” query with LINQ?
  10. LINQ Grouping dynamically
  11. Linq list of lists to single list
  12. LINQ Where Ignore Accentuation and Case
  13. Edit specific Element in XDocument
  14. ILookup vs. IGrouping
  15. Enumerating Collections that are not inherently IEnumerable?
  16. Comparing 2 objects and retrieve a list of fields with different values
  17. C# Linq where clause as a variable
  18. Find if listA contains any elements not in listB
  19. How to merge a list of lists with same type of items to a single list of items?
  20. Split an IEnumerable into fixed-sized chunks (return an IEnumerable where the inner sequences are of fixed length) [duplicate]
  21. Filling a DataSet or a DataTable from a LINQ query result set
  22. Compare Two Lists Via One Property Using LINQ
  23. How does PredicateBuilder work
  24. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  25. Why use .AsEnumerable() rather than casting to IEnumerable?
  26. Only parameterless constructors and initializers are supported in LINQ to Entities message
  27. Combining The Results Of Two Linq Queries Into A Single Var?
  28. selecting a property from FirstOrDefault in case FirstOrDefault returns null
  29. Use LINQ to move item to top of list
  30. Entity Framework select one of each group by date

Leave a Comment