||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.|
Get Sams Teach Yourself ADO.NET in 24 Hours now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.