Return multiple recordsets from stored proc in C#

Return multiple recordsets from stored proc in C#

I am having to convert an ASP classic system to C#
I have a stored procedure that can return up to 7 recordsets (depending on
the parameters passed in).
I need to know how I can simply return all the recordsets as individual
DataTables so that I can loop through whatever is there, skipping to the
next DataTable when I get to the end of it without having to run multiple
SQL statements and use multiple adapter.Fill statements to add each table
into a DataSet.
In classic it was a simple Do While not objRS.EOF loop with a
objRS.NextRecordset() when I got to the end of the loop to move to the
next statement.
Is there anything I can use that doesn't require a total rewrite of the
current back end code?
Each recordset has a different number of columns and rows. They are
unrelated to each other. We return multiple recordsets from Stored Proc's
to reduce traffic.
Examples would be nice.
Thanks