Dataset / memory replacements

Question

Is there a replacement for Dataset, so the data is saved on disk, not stored in memory? I have to fill a dataset with a huge amount of data, which may cause memory exceptions. I can not do anything to reduce the amount of data, because it depends on the requirements of the user.

Answer 1

I would check if it can be used instead DataReader, since then you processed the records as they arrived from the database, and did not first store everything in memory.