title: How to select only the records with the highest date in LINQ
body: <p>I have a table, 'lasttraces', with the following fields.</p>
  
  <pre><code>Id, AccountId, Version, DownloadNo, Date
  </code></pre>
  
  <p>The data looks like this:</p>
  
  <pre><code>28092|15240000|1.0.7.1782|2009040004731|2009-01-20 13:10:22.000
  28094|61615000|1.0.7.1782|2009040007696|2009-01-20 13:11:38.000
  28095|95317000|1.0.7.1782|2009040007695|2009-01-20 13:10:18.000
  28101|15240000|1.0.7.1782|2009040004740|2009-01-20 14:10:22.000
  28103|61615000|1.0.7.1782|2009040007690|2009-01-20 14:11:38.000
  28104|95317000|1.0.7.1782|2009040007710|2009-01-20 14:10:18.000
  </code></pre>
  
  <p>How can I, in <a href="http://en.wikipedia.org/wiki/Language_Integrated_Query#LINQ_to_SQL" rel="noreferrer">LINQ&nbsp;to&nbsp;SQL</a>, only get the last lasttrace of every AccountId (the one with the highest date)?</p>