What is the best approach for synchronizing a DataSet with data in a database? Here are the options:
- We cannot just reload the data because it is associated with a user interface control that the user can configure (this is a tree grid that they can expand / collapse)
- We cannot use changeflag (for example, UpdateTimeStamp) in the database, because changes do not always flow through the application (for example, the database administrator can update the field using the SQL statement)
- We cannot use the update trigger in the database because it is a multi-user system
- We use ADO.NET DataSets
- Multiple fields can modify a given string
I looked at the possibility of merging a DataSet, but this does not seem to contain the concept of an “ID” column. I looked at the features of DiffGram, but the problem here is that they seem to be generated from changes within the same dataset, and not due to changes that occurred at some external data source.
I worked with this solution for some time, but the approach that I know will work (with great inefficiency) is to create a separate DataSet, and then repeat all the lines that apply the changes, fields by field, to the DataSet on which it is connected .
Has anyone had a similar scenario? What did you do to solve the problem? Even if you have not encountered a similar problem, any recommendation for a solution is appreciated.
thank
t3rse source
share