LINQ order by null column where order is ascending and nulls should be last

by

Try putting both columns in the same orderby. 

orderby p.LowestPrice.HasValue descending, p.LowestPrice

Otherwise each orderby is a separate operation on the collection re-ordering it each time.

This should order the ones with a value first, “then” the order of the value.

More Related Contents:

  1. Preserving order with LINQ
  2. Sort a list from another list IDs
  3. Alphanumeric sorting using LINQ
  4. How do I sort strings alphabetically while accounting for value when a string is numeric?
  5. List sort based on another list
  6. The data source does not support server-side data paging
  7. LINQ Custom Sort
  8. List complex sorting
  9. Sort one list by another
  10. Better way to sort array in descending order
  11. Use LINQ to move item to top of list
  12. Sum multidimensional array over dimensions [closed]
  13. LINQ query on a DataTable
  14. Deserializing JSON to .NET object using Newtonsoft (or LINQ to JSON maybe?)
  15. Use LINQ to get items in one List, that are not in another List
  16. How to combine more than two generic lists in C# Zip?
  17. Select parsed int, if string was parseable to int
  18. What is the point of Lookup?
  19. String sorting issue in C#
  20. Enumerating through an object’s properties (string) in C#
  21. How to get first record in each group using Linq
  22. Sort a Custom Class List
  23. How to check for nulls in a deep lambda expression? [duplicate]
  24. What does LINQ return when the results are empty
  25. How do I do a left outer join with Dynamic Linq?
  26. LINQ performance FAQ
  27. How to get/find an object by property value in a list
  28. Case insensitive XML parser in c#
  29. Select multiple fields group by and sum
  30. Linq – Top value from each group

Leave a Comment