title: Get the sum of multiple columns
body: <p>I have three columns, which I am trying to get the sum of each one returned. I can do it for one column:</p>
  
  <pre><code>var data = db.Test.Sum(x =&gt; x.Column1);
  </code></pre>
  
  <p>I can't figure out how to get the sum for three columns though. I tried selecting the values into and summing them, but that didn't work.</p>
  
  <pre><code>var data = db.Test.Select(x=&gt; new { x.Column1, x.Column3, x.Column3}).Sum();
  </code></pre>
  
  <p>I am after the result of each column separately, not a sum of all the columns. </p>