title: How do I use and view data from SQL Group By and SQL Aggregates with Dapper?
body: <p>If I have an SQL statement like,</p>
  
  <pre><code>SELECT Count(id) as TotalRows, transaction_date
  FROM Accounts
  Group By transaction_date
  </code></pre>
  
  <p>What do I use as a return type an display it in my View using Dapper Dot Net?  I tried using <code>ViewData["mydata"]</code> and I tried using <code>List&lt;dynamic&gt;</code>, but I could not iterate because the return type is <code>IActionResult</code> and as such does not have an Enumerator.  I can't cast it (I don't know how to) to a specific type with <code>IEnumerable</code> because there is not custom type like (Accounts, Person, etc.).  None of these have a property for enumerating.</p>
  
  <p>I would like to not use Linq unless it is necessary.</p>