title: Dapper with Multiple Records from Stored Procedure
body: <p>I have seen the answer to this question, <a href="https://stackoverflow.com/questions/6751052/how-to-map-multiple-records-from-a-single-sp-with-dapper-dot-net">How to map multiple records from a single SP with Dapper-dot-net</a>, but it doesn't seem to work for my scenario.</p>
  
  <p>Dummy Tables for illustration...</p>
  
  <p>I have a SP that returns multiple record sets, and the first one looks like...</p>
  
  <pre><code>Column1 (int), Column2 (int)
  </code></pre>
  
  <p>and I have a class... </p>
  
  <pre><code>public class Columns
  {
      public int Column1 { get; set; }
      public int Column2 { get; set; }
  }
  </code></pre>
  
  <p>Then, I am trying to build a list of columns...</p>
  
  <pre><code>        using (var conn = new SqlConnection(...))
          {
              using (var multi = conn.QueryMultiple("SpData", 
                     commandType: CommandType.StoredProcedure))
              {
                  var cols = multi.Read&lt;Columns&gt;().ToList();
              }
          }
  </code></pre>
  
  <p>When I call this, nothing seems to be populated in the <code>cols</code> variable, but I am not getting any errors.  Also, if I break and look at what <code>multi</code> contains, I can see the data there.  Can somebody see where I am going wrong?</p>