title: Dapper Dynamic QueryMultiple
body: <p>I'm wanting to query 2 tables and return 2 result sets using dapper.</p>
  
  <p>Here is the code i'm trying.</p>
  
  <p>This code builds but QueryMultiple looks like its not able to get the second result set or something. I have tried looping the results and using .Read() which is dynamic. </p>
  
  <p>Do you think it could not be working because i'm trying to add 2 different sizes of tables to a single dynamic list?</p>
  
  <pre><code>    public virtual IEnumerable&lt;dynamic&gt; QueryDatabase(Report report)
      {
          if (report == null) return null;
          using (var conn = new SqlConnection(this.configurationHelper.GetConnectionStringByName(report.ConnectionName)))
          {
              conn.Open();
              var sql = report.Query;
              //var results = conn.QueryMultiple(sql).Read&lt;dynamic&gt;();
  
              using (var multi = conn.QueryMultiple(sql))
              {
                  var result = new List&lt;dynamic&gt;();
  
                  foreach (var item in multi.Read())
                  {
                      result.Add(item);
                  }
                  return result;
              }
          }
      }
  </code></pre>