title: Read multiple result sets using query multiple
body: <p>My procedure is returning two result sets/tables,
  I want to read those two result sets into two different lists and bind that list.</p>
  
  <p>I'm able to read one result set into a list but I tried various ways to read multiple result sets into the dynamic list but it is giving me "TTC Error Oracle".</p>
  
  <p>How to read multiple result sets using QueryMultiple?</p>
  
  <p>Code for reading single result set into dynamic list:</p>
  
  <pre><code>public ResponseModel GetDoctorDetails(CustomerRequest data)
  {
      try
      {
          var p = new OracleDynamicParameters();
          p.Add("p_parameter1", data.PARAMETER1, dbType: OracleDbType.Int32, direction: ParameterDirection.Input, size: 8);
          p.Add("p_parameter2", data.PARAMETER2, dbType: OracleDbType.Int32, direction: ParameterDirection.Input, size: 8);
          p.Add("p_out_cursor", dbType: OracleDbType.RefCursor, direction: ParameterDirection.Output, size: 0);
          using (var multi = _oracleConnection.QueryMultiple("procedure_name", param: p, commandType: CommandType.StoredProcedure))
          {
              List&lt;dynamic&gt; list = multi.Read&lt;dynamic&gt;().AsList();
  
              return new ResponseModel { ResultSet = list, StatusCode = 1, StatusDescription = "Success" };
          }
      }
      catch (Exception ex)
      {
          throw ex;
      }
  }
  </code></pre>
  
  <p>I tried following ways to read multiple result sets but it is giving me "TTC Error"</p>
  
  <pre><code>List&lt;DataTable&gt; list = new List&lt;DataTable&gt;();
  list = multi.Read&lt;DataTable&gt;().AsList();
  </code></pre>
  
  <p>and</p>
  
  <pre><code>List&lt;List&lt;dynamic&gt;&gt; list = new List&lt;List&lt;dynamic&gt;&gt;();
  list = multi.Read&lt;List&lt;dynamic&gt;&gt;().AsList();
  </code></pre>
  
  <p>Please help.</p>