Hello folks, i'm working in an app that was originally built to connect to SQL Server by using ADO.NET SqlClientProvider. Recently, i had to generalize the data provider code to work with either SQL Server or Oracle (by using DbClasses instead of SqlClasses and so on...).
My problem is: Oracle SPs need to use ref cursors to retrieve table data to the app and i don't want to add output parameters to EVERY SINGLE data retrieval method in the app if it is connecting to Oracle. Is there any way to implicity retrieve these cursors without having to specify the output parameters? (i.e, by just calling DbCommand.ExecuteReader()).
I thank in advance :-)