You need to write a method that retrieves data from a Microsoft Access 2013 database. The method
must meet the following requirements:
Be read-only.
Be able to use the data before the entire data set is retrieved.
Minimize the amount of system overhead and the amount of memory usage.
Which type of object should you use in the method?
A.
DbDataAdapter
B.
unTyped DataSet
C.
OleDbDataAdapter
D.
DbDataReader
Explanation:
The DbDataReader class reads a forward-only stream of rows from a data source.DbDataReader Class
https://msdn.microsoft.com/en-us/library/system.data.common.dbdatareader(v=vs.110).aspx
C
0
0
D is correct
1
0
C
0
0
http://stackoverflow.com/questions/15128361/getting-data-from-ms-access-database-and-display-it-in-a-listbox
0
0
answers are wrong,
OleDbDataReader is correct
0
0
yes i agree with msdn. answer should be datareader right. access implementation is olddbdatareader
0
0
What is the difference between DbDataReader & OleDbDataReader?
I’ve looked it up but I still don’t get it. Can someone explain?
0
0
Correct answer: DbDataReader
OLEDBDataAdapter is the one which gives Flexibility to edit/Delete/insert the data. In comparision with DataReader you would find a DataAdapter slower.
0
0
Ty. But I was asking about OleDbDataREADER (it’s not among possible answers, I just wanted to know the difference between those two readers).
0
0