title: How to sort a List collection of classes with properties in them?
body: <p>I have a List of classes in my collection like</p>
  
  <pre><code>List&lt;MyClass&gt; test = new List&lt;MyClass&gt;();
  </code></pre>
  
  <p>In my classes I have just some properties</p>
  
  <pre><code>public string id {get; set;}
  public DateTime date {get; set;}
  </code></pre>
  
  <p>Now I make these classes by getting some queries from 2 different database tables. I then take those 2 results from the database tables and using a foreach loop I make a new MyClass object and stick it in my "test" collection.</p>
  
  <p>Now once all these classes are put in the the list collection. I want to sort through them and order the classes by the "date" property.</p>
  
  <p>How could I do this? I can't order then right when I get them from the database since I am getting them from 2 different database tables and ordering them separately would only make it ordered in for each section but table one might have 12/12/2009 and so might table two. So they need to be ordered together.</p>
  
  <p>So can I some how use linq or something to order them?</p>
  
  <p>Thanks</p>