Hi,

I am creating an DAL which will pass a stored procedure to Oracle Data base with 5 return (out) cursors. All these out cursors are different tables from oracle and are interlinked with eachother with primary and foriegn keys. I need to read the fist cursor and use the relationship to loop through the other four cursors and fill them in a business object. As this involves of reading only and volume of data that comes out , I choose to use OracleDataReader over datasets which will be perfromance issue and am writing code in C#

My questions :
How to loop through all these cursors with the relationship?
I can use :

OracleDataReader dr = cmd.ExecuteReader();
while(dr.read())
{
/Fill the data for the object
}
dr.NextResult()
..

But here I dont know how to relate the cursors.

Do I need to fill everyhting first in a Table and can associate it?
Any help/suggestions will be appreciated.

Thanks