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.
Sql DataReader

B.
Sql Data Adapter

C.
OleDb DataReader

D.
OleDb DataAdapter