title: C# List Sort by Time in Reverse Chronological Order
body: <p><strike>I am saving Time field in my sql server database as nvarchar  in ("HH:mm") format.</strike></p>
  
  <p>Upon the suggestion of EVERYONE. I now saved the time in my sql server database in DateTime format. Though I won't be needing the date part, I will use this property so that I can achieve the effect Im trying to do.
  Now what I want to do is get a list of row in reverse chronological order based on the current time of execution. For example if my table looks like this:</p>
  
  <pre><code>tblFavoriteTime
  ID     Time       Post
  1     05:00 AM    Something..
  2     09:00 AM    Another..
  3     12:00 PM    Hello..
  4     01:00 PM    Its 8 am..
  </code></pre>
  
  <p>When I visit the site at 12:00PM, I need the list of time in reverse chronological order. So 12:00PM will be at the top of the list, <code>12:00PM -&gt; 11:00AM -&gt; 10:00AM -&gt; .... 1:00AM -&gt; 12:00AM -&gt; 01:00PM -&gt; 02:00PM -&gt; ..... 11:00PM</code> Using the data above, I should get:</p>
  
  <pre><code>ID     Time         Post
  3     12:00 PM      Hello...
  2     09:00 AM      Another..
  1     05:00 AM      Something..
  4     01:00 PM      Its 1 pm..
  </code></pre>
  
  <p>Is there a way to do this using <code>LinQ .OrderBy()</code> or something like this:</p>
  
  <pre><code>var mylist = _repository.GetAll().ToList()
              .OrderBy(x =&gt; x.TimeStamp.TimeOfDay() .......); 
              //as I explained, Im only getting the time of day though its a datetime object, date part wont matter..
  </code></pre>
  
  <p>Please help!</p>