Use DataReader: A DataReader is a forward-only, read-only cursor, which is?

memory-efficient and fast for large result sets. It reads data row-by-row instead of

loading everything into memory at once, like a DataSet.