Existing algorithm for merging DataSets after GetChanges() and withidentity column?

[Frank Hauptlorenz]

Dear all,

is there an algorithm existing so that I can use DataTables within
DataSets with identity columns together with GetChanges()?

Let me explain this step by step:
- Complex DataSet is existing / modified on the client, Rows with
Identity columns are created
- Only the Changes are send to the server with GetChanges()
- The DataSet is saved to the SQL Server within the TableAdapterManager
- The DataSet is send back to the client including the new Identity
column values

-> How can I now merge the changes back to the Client DataSet?

I can create a new algorithm for this but like to use an existing one.

Thank you,
Frank

 

[Frank Hauptlorenz]

Dear all,

I've written now an own algorithm which sends the new Identity-Columns
in the changed DataSet back to the Client and changes them there (with
cascading updates within the DataSet).
Then it merges all the changes back to the local DataSet on primary key
base.

Works like hell.
Frank