title: LINQ | How do I get SUM without grouping?
body: <p>Crazy question...however, I want the sum of all the rows in a table for a column (without using the group by clause)</p>
  
  <p>Example:</p>
  
  <pre><code>Table = Survey
  Columns = Answer1, Answer2, Answer3
          1        1         1
          4        3         5
          3        3         2
  </code></pre>
  
  <p>I want the sums for each column.</p>
  
  <p>Final results should look like: </p>
  
  <pre><code>Answer1Sum  Answer2Sum  Answer2Sum
  
  8           7           8
  </code></pre>
  
  <hr>
  
  <p>This doesn't work:</p>
  
  <pre><code>from survey in SurveyAnswers
  select new
  {
      Answer1Sum = survey.Sum(),
      Answer2Sum = survey.Sum(),
      Answer3Sum = survey.Sum()
   }
  </code></pre>
  
  <hr>