Recordset with multiple resultsets
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();
...
}