You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
You plan to implement a data access component to retrieve product data from a corporate database.
The component will return data for the products that meet the defined criteria.
You need to ensure that the component conforms to the following requirements:
– Access to the database is provided only when necessary.
– The database schema is hidden from the application that calls the component.
– Calls are returned by the component as quickly as possible.
What should you do?
A.
Create a typed collection.
Use System.Linq to verify the cached collection.
Retrieve all products if data is not cached.
B.
Create a typed collection.
Use System.Linq to verify the cached collection.
Retrieve a subset of products if data is not cached.
C.
Create a DataTable object.
Use the Select method to verify whether the object contains the necessary data.
Retrieve all products if data is not cached.
D.
Create a DataTable object.
Use the Select method to verify whether the object contains the necessary data.
Retrieve a subset of products if data is not cached.