title: LINQ-To-SQL OrderBy with DateTime Not Working
body: <p>I have this LINQ query.  The date is stored as a string in the database, but I need to order by it.  So I convert it to a DateTime, but it doesn't order.</p>
  
  <pre><code>   (from m in dbDataContext.TimeCards
      where m.TIMECARDDATE != ""
      &amp;&amp; m.TIMECARDDATE != null
      orderby Convert.ToDateTime(m.TIMECARDDATE) descending
      select Convert.ToDateTime(m.TIMECARDDATE)).Distinct().ToList();
  </code></pre>
  
  <p>Any idea why it doesn't work? I can't change the database, so I have to deal with the data the way it is. I get the data back ordered like this...</p>
  
  <pre><code> 2/27/2009
   2/26/2009
   2/25/2009
   2/28/2009
   2/24/2009
  </code></pre>