Set ResolveToDataSet to specify how updates are applied. When ResolveToDataSet is true, the Resolver property is set to a TDataSetResolver component, which applies updates directly to the dataset specified by the DataSet property. This can be useful if the application uses the events on the dataset component or if the dataset does not represent the data from a database server (for example, a client dataset). 

When ResolveToDataSet is false, the Resolver property is set to a TSQLResolver component, which applies updates directly to the database server associated with DataSet. This can be more efficient, because it skips the intermediate step of using the dataset. It is the only way to resolve updates if the source dataset is read-only (for example, a unidirectional dataset). 

DataSet 

Resolver 

Choosing How to Apply Updates Using a Datasetm Provider