I am writing a system that talks to Oracle Stored Procedures. For the ones that return cursors, LLBL gives me 2 options. Readers and Datasets/DataTables.
Is there a general rule I should follow in choosing between Readers and Datasets to get data back? Results size etc?
Please read DataReaders and Projections
I'd always go for DataSets, unless there is a specific requirement for having a DataRader as explained in the first section of the documentation.