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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.