Ado. net does not require that you keep a continuous live connection to the database and process one retrieved record at a time. additional classes are available that enable you to connect to the database long enough to retrieve records into memory.
the primary class for this activity is

a. datareader
b. connection
c. command
d. dataset

DataSet

Explanation:

DataSet is primary in supporting disconnected distributed Datasets with ADO.NET.

this seems to be in the wrong category. but i'll take some free points my dude

posting this in wrong category will result in people seeing it who won't know the answer.

yes, but you must first make sure that you'll be able to make your turn or you can crash into other vehicles.