At the moment I use a DataAdapter to read from a stored procedure and store the results in a dataset which is then cached.
I have heard that the DataAdapter can give poor performance, so I am considering using a datareader instead of the dataadapter but I would like to keep the dataset so that it can be cached.
Can anyone tell me whether it is the DataAdapter that performs badly or the DataSet ? (i.e. will I waste a lot of time for no gain if I re-code to implement a DataReader?)