You are creating a Windows application by using the .NET Framework 3.5. The application connects to a database within the corporate network. It retrieves data from a read-only database. The database contains a table named Customers. An XML file that contains new customer data is periodically provided to the application. The XML file has the following specifications:
* It has the same schema as that of the Customers table.
* It will be integrated into the Customers table.
* It will be removed after data integration.
The application requires data from the Customers table and the XML file to bind to a DataGridView control.
You need to ensure that data can be retrieved together from the two data sources by using minimum development effort. What should you do?
A.
Load data from the two data sources into DataSet objects. Merge the data present in the DataSet objects.
B.
Read data from the Customers table as an XML object. Use the XSLT style sheet to merge data with the original XML file.
C.
Load data from the Customers table into a new XML file. Open the XmlReader object to read the two XML files. Merge the XML files.
D.
Create a temporary table in the database. Load data from the XML file into the temporary table. Retrieve data simultaneously from the temporary table and the Customers table.