title: Dapper QueryAsync, return a list
body: <p>I have this task in C# with which i want to call a stored procedure in MySql using dapper.</p>
  
  <pre><code>public async Task&lt;List&lt;StatItemListViewModel&gt;&gt; GetTable()
      {
          using (MySqlConnection connection = new MySqlConnection(Helper.CnnVal("SampleDB")))
          {
              var results =await connection.QueryAsync&lt;List&lt;StatItemListViewModel&gt;&gt;("Call MainResult_Statistic(@sDate, @eDate)", new { sDate = "2018-11-01", eDate = "2018-11-30" });
  
              return results.FirstOrDefault();
          }            
      }
  </code></pre>
  
  <p>The problem is that it doesn't return anything.</p>
  
  <p>Can someone help me please?</p>