You create Web-based client applications. You are designing a procedure to retrieve product data from a database. The product data will be displayed on several pages of your Web site. The data will be filtered and sorted by different parameters and will be displayed in grids with paging. Users will not be able to modify the data that is displayed on the Web site. The product data is stored in a database on an instance of Microsoft SQL Server that is located on a different server. The database is configured to support SQL cache invalidation. You need to ensure that the data is retrieved such that the pages of the Web site load as quickly as possible. What should you do?
A.
Use a SqlDataReader object.
B.
Use a DataTableReader object.
C.
Use a DataTable object.
D.
Use a SqlDataAdapter object.