You are creating an ASP.NET application by using the .NET Framework 3.5.
The application will contain a Data Access Layer (DAL) that will support databases from third-party vendors. The application will display data by using a GridView control.
You need to ensure that the application meets the following requirements:
* Allow paging
* Provide optimistic concurrency
Which data access object should you use in the DAL?
A.
SqlDataReader
B.
SqlDataAdapter
C.
OleDbDataReader
D.
OleDbDataAdapter