When a SQL script produces multiple resultsets, the resultsets are defined as nested classes inside the recordset class.


The recordset has properties like "Resultset1" and "Resultset2" that hold a resultset class instance.


Recognizing a multiple resultset class

The recordset class only implements the IRecordsetBase interface:


public partial class MultiRecordset : IRecordsetBase


The class summary displays "This recordset contains x resultsets."


/// <summary>

/// This recordset contains 2 resultsets.

/// </summary>


In the constructor you can see the resultset classes being initialized:


public MultiRecordset()

{

       _resultset1 = new MultiResultsetCustomers();

       _resultset2 = new MultiResultsetPatient();

   ...

}