for RuBoard |
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. |
for RuBoard |