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();