True or false: There is little overhead associated with the DataReader object.
True. There is never any more than one database record in memory while the DataReader is open and retrieving data. This makes it very lightweight compared to the DataAdapter , particularly when a large number of records are being returned.
What is the key difference between the DataReader and DataAdapter ?
The DataAdapter stores the results of a database query into a DataSet object. The DataReader opens a pipe directly from the database to the data's destination.