title: LINQ order by null column where order is ascending and nulls should be last
body: <p>I'm trying to sort a list of products by their price. </p>
  
  <p>The result set needs to list products by price from low to high by the column <code>LowestPrice</code>. However, this column is nullable. </p>
  
  <p>I can sort the list in descending order like so:</p>
  
  <pre><code>var products = from p in _context.Products
     where p.ProductTypeId == 1
     orderby p.LowestPrice.HasValue descending
     orderby p.LowestPrice descending
     select p;
  
  // returns:    102, 101, 100, null, null
  </code></pre>
  
  <p>However I can't figure out how to sort this in ascending order.</p>
  
  <pre><code>// i'd like: 100, 101, 102, null, null
  </code></pre>