public void MultipleResultSetsTest ()
{
DataTable dt1 = new DataTable ("test2");
dt1.Columns.Add ("x", typeof (string));
dt1.Rows.Add (new object [] {"test"} );
dt1.Rows.Add (new object [] {"test1"} );
dt1.AcceptChanges ();
DataTable [] collection = new DataTable [] { dt, dt1 } ;
DataTableReader reader = new DataTableReader (collection);
try {
int i = 0;
do {
while (reader.Read ())
i++;
} while (reader.NextResult ());
Assert.AreEqual (5, i, "#1 rows should be of both the tables");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}