Hour 8

Quiz Answers

1: True or false: There is little overhead associated with the DataReader object.
A1: 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.
2: What is the key difference between the DataReader and DataAdapter?
A2: 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.