title: Include both COUNT(*) and Sum(X) in a single async query Entity Framework
body: <p>In my ASP.NET MVC project I'm trying to achieve the equivalent of this SQL Server code:</p>
  
  <pre><code>SELECT COUNT(*) as TotalCount, SUM(SomeColumn) as TotalSum 
  FROM SomeTable
  WHERE param1 = 'foo' AND param2 = 'bar'
  </code></pre>
  
  <p>...with Entity Framework in a single async query. Essentially I'm looking to get not only the sum, but also the number of rows used to calculate the sum of the <code>SomeColumn</code> column in a single call.</p>
  
  <p>So far I've only managed to do this in two calls:</p>
  
  <pre><code>using (var context = new myEntities())
  {
      // 1st query which does .SumAsync(x =&gt; x.SomeColumn)
      // 2nd query which performs a .Count() on the result set
  }
  </code></pre>
  
  <p>Is it possible to do this in one async call, like the SQL provided above? Should I just create a view or stored proc on the SQL side?</p>