Memory Efficiency:?

• A DataReader is a forward-only, read-only cursor, meaning it streams data

from the database and does not store the entire result set in memory.

• DataSet, on the other hand, loads the entire result set into memory, which

can consume significant memory for large datasets.