title: If Statement within Linq Query
body: <p>I am attempting to sort dropdownlist just exactly how it is entered in the database only if a specific id is selected. Otherwise I want them to sorted in ascending order. I was not sure how to add the final component of not sorting the list when a particular Id is selected. Here is where i am so far:</p>
  
  <pre><code>var items = (from p in _db.Funds
                       where p.DesignationId == id
                       orderby p.Name ascending 
                       select new { p.id, p.Name });
          return items;
  </code></pre>