Is there any way to use Dapper.NET with stored procs that return multiple result sets?

In my case, the first result set is a single row with a single column; if it&#39;s `0` then the call was successful, and the second result set will contain that actual rows/columns of data. (and if it was non-zero, an error occured and no second result set will be provided)

Any chance to handle this with Dapper.NET? So far, I&#39;m only ever getting back that single `0` - but nothing more.

**Update:** OK, it works fine - as long as the result set no. 2 is a single entity:

    Dapper.SqlMapper.GridReader reader = 
        _conn.QueryMultiple(&quot;sprocname&quot;, dynParams, 
        commandType: CommandType.StoredProcedure);

    int status = reader.Read&lt;int&gt;().FirstOrDefault();
    MyEntityType resultObj = reader.Read&lt;MyEntityType&gt;().FirstOrDefault();

Now, I have **yet another** requirement.

Dapper&#39;s multi-mapping (splitting up a single row returned from SQL Server into two separate entities) for that second result set doesn&#39;t seem to be supported as of yet (at least there doesn&#39;t seem to be an overload of `.Read&lt;T&gt;` that can handle multi-mapping).

How can I get split that row into two entities?

All Multiple Resultsets Solutions on Gang of Coders

Total of 1 Multiple Resultsets Solutions

Dapper.NET and stored proc with multiple result sets