title: Linq to sql: Order by datetime desc, then order by the time part of the data asc?
body: <p>This is a quick one. <br />
  In Linq to sql, I need to order by a datetime field descending then order by the time part of the same datetime filed ascending, make sense? Here's an example of the result needed: <br /> <br />
  [Serial] [Date (mm-dd-yyyy:hh-MM-ss)] <br >
  1         3-13-2008:10-10-02 <br >
  2         3-13-2008:10-12-60 <br >
  3         3-12-2008:12-05-55 <br >
  <br /> <br /></p>
  
  <p>I tried : <br /></p>
  
  <pre><code>return query.OrderByDescending(c=&gt; c.Time).ThenBy(c=&gt; c.Time.TimeOfDay);
  </code></pre>
  
  <p><br />
  And also tried: <br /></p>
  
  <pre><code>query.OrderByDescending(c =&gt; c.Time).ThenBy(c =&gt; c.Time.Hour).ThenBy(c=&gt; c.Time.Minute).ThenBy(c=&gt; c.Time.Second);
  </code></pre>
  
  <p><br />
  but never seemed to work. 
  Any suggestions?</p>