You are creating a smart client application. When the application is offline, it writes changes and additions to a DataSet to a local file. When the application returns online, it retrieves a new DataSet from a DataAdapter. You must merge the newly retrieved DataSet with the persisted DataSet, ensuring that changes to the persisted DataSet are preserved.

What should you do?

Posted by Rajkatie on 9/30/2012 | Category: ADO.NET Interview questions | Views: 2723 | Points: 40

Select from following answers:

Call the DataSet.Merge method on the persisted DataSet with the new DataSet. Specify that PreserveChanges is True.
Call the DataSet.Merge method on the persisted DataSet with the new DataSet. Specify that PreserveChanges is False.
Call the DataTable.Copy method for each DataTable in the new DataSet and add the copied DataTable to the persisted DataSet.
All Above