title: Sum of multiple columns in a LINQ query
body: <p>I've this table: Statistics(id int, col1 int, col2 int, col3 int ...)
  I want to get the sum of the col1 values, col2 values, col3 values etc. 
  <strong>A simple sql query:</strong></p>
  
  <pre><code>SELECT SUM([Col1]), SUM([Col2])
  FROM [dbo].[Statistics]
  </code></pre>
  
  <p>but in LINQ:</p>
  
  <pre><code>var val1 = db.Statistics.Sum(x =&gt; x.Col1);
  var val2 = db.Statistics.Sum(x =&gt; x.Col2);
  var val3 = db.Statistics.Sum(x =&gt; x.Col3);
  ...
  </code></pre>
  
  <p>In this way works, but this executes N queries on the database. I would like execute only one. The only way that I found is this:</p>
  
  <pre><code>var result = db.Statistics.GroupBy(x =&gt; 1).Select(x =&gt; new
  {
     val1 = x.Sum(k =&gt; k.Col1),
     val2 = x.Sum(k =&gt; k.Col2),
     val3 = x.Sum(k =&gt; k.Col3),
  });
  </code></pre>
  
  <p>that it generate a complex query. 
  is it normal? </p>
  
  <p><strong>UPDATE</strong>
  these are the 2 execution plans:</p>
  
  <p><img src="https://i.stack.imgur.com/Ss1kx.png" alt="enter image description here"></p>