title: aggregate and distinct linq query output to list
body: <p>How can I transform linq query output using aggregate operators and display distinct outputs to a list?</p>
  
  <p>Here is what I have stored in DB, which is being pulled via linq query:</p>
  
  <pre><code>   Date        Hours
  07/29/2013      1.3
  07/29/2013      2.0
  07/30/2013      3.1
  07/31/2013      0.1
  07/31/2013      5.2
  08/01/2013      1.1
  08/01/2013      1.1
  08/01/2013      2.2
  08/02/2013      3.3
  08/02/2013      4.0
  08/03/2013      2.1
  </code></pre>
  
  <p>Here is how I want the data:</p>
  
  <pre><code>   Day          Hours
  07/29/2013       3.3
  07/30/2013       3.1
  07/31/2013       5.3
  08/01/2013       4.4
  08/02/2013       7.3
  08/03/2013       2.1
  </code></pre>
  
  <p>Any help is much appreciated</p>