You are an enterprise application developer. You are designing a data access component to meet the following criteria:
The data access component provides data to several business components. The data access component contains methods that retrieve data. The methods retrieve data from a Microsoft SQL Server database.
The data is modified infrequently.
You need to ensure that the data access component provides current data to the business components.
You also need to minimize the number of requests sent to the SQL Server database for this data.
What should you do?
A.
Ensure that the data retrieval methods use SqlDependency objects.
B.
Ensure that the data retrieval methods use DataAdapter objects that have Batch Updates enabled.
C.
Ensure that the data retrieval methods are explicitly enlisted in distributed transactions.
D.
Ensure that the data retrieval methods use asynchronous methods of the SqlCommand class.