You are creating a Web application for an enterprise solution by using Microsoft SQL Server 2008 and the .NET Framework 3.5. The application environment has the following specifications:
Several users access the same data.
Data does not change frequently.
The database schema is as shown in the exhibit. (Refer to the Exhibit.)
You need to build the business logic layer to meet the following requirements:
Support the DataRelation class.
Minimize redundant data.
Maintain the design of the original schema.
What should you do?
A.
Populate SalesOrderHeader objects for the primary key.
Populate a SalesOrderDetail object for each associated foreign key.
Save the SalesOrderDetail objects in the memory cache for subsequent data retrieval.
B.
Populate SalesOrderAll objects that contain all fields from the SalesOrder and SalesOrderDetail tables.
Save the SalesOrderAll objects in the memory cache for subsequent data retrieval.
C.
Populate SalesOrderHeader objects for the primary key.
Populate a SalesOrderDetail object for each associated foreign key.
Save the SalesOrder objects in the memory cache for subsequent data retrieval.
D.
Populate SalesOrderHeader objects for the primary key by using a field that contains the foreign key.
Implement a method to populate the SalesOrderDetail object that matches the associated foreign key.
Call the implemented method when a field is required.