DISTINCT() and ORDERBY issue

by

From the Queryable.Distinct documentation;

The expected behavior is that it returns an unordered sequence of the unique items in source.

In other words, any order the existing IQueryable has is lost when you use Distinct() on it.

What you want is probably something more like this, an OrderBy() after the Distinct() is done;

var query = (from o in db.Orders
             select new
             {
                 o.CustomerID
             }).Distinct().OrderBy(x => x.CustomerID);

More Related Contents:

  1. LINQ – Left Join, Group By, and Count
  2. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  3. LINQ Where Ignore Accentuation and Case
  4. Operation could destabilize the runtime?
  5. How to select only the records with the highest date in LINQ
  6. Max or Default?
  7. How do I do a left outer join with Dynamic Linq?
  8. Get sum of two columns in one LINQ query
  9. Last and LastOrDefault not supported
  10. Linq where column == (null reference) not the same as column == null
  11. Prevent duplicates from array, based on condition [closed]
  12. Return anonymous type results?
  13. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  14. What guarantees are there on the run-time complexity (Big-O) of LINQ methods?
  15. How to do a subquery in LINQ?
  16. How to get the index of an element in an IEnumerable?
  17. LINQ: Not Any vs All Don’t
  18. How to check if IEnumerable is null or empty?
  19. LINQ: combining join and group by
  20. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  21. How to take all but the last element in a sequence using LINQ?
  22. Cannot implicitly convert type ‘System.Collections.Generic.IEnumerable’ to ‘System.Collections.Generic.List
  23. LINQ Expression to return Property value?
  24. Max return value if empty query
  25. How to do an “in” query in entity framework?
  26. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  27. Should the order of LINQ query clauses affect Entity Framework performance?
  28. Map two lists into a dictionary in C#
  29. Is Injection Possible through Dynamic LINQ?
  30. Can I use Linq’s Except() with a lambda expression comparer?

Leave a Comment