Hi JuneT,
Thanks for your reply, In the above example it is for ClientUpdateServerUpdate scenario and they also using GUID column as a primary key.
Here in this case we have Primary key data type is integer. When client insert a row with some primary key and server also inserts the row with same primary key. So as a result I want both rows to be merged in both database. See example below for more explanation.
Example:
Customer (Client db) (we have customer client db, which has inserted one row with primary key 100)
Customer_id(PK) name, city
100 abc NY
Customer (Server db) (we have customer server db, which has inserted one row with primary key 100)
Customer_id(PK) name, city
100 xyz SFO
While synchronizing it will detect the ClientInsertServerInsert conflict, so I want it to resolve as merge resolution and after synchronization data will be like this in both tables
Client table
Customer_id(PK) name, city
100 abc NY
101 xyz SFO
--------------------------------------------
Server table
Customer_id(PK) name, city
100 abc NY
101 xyz SFO
What could be the possible solution for this, can't Sync framework handle this by default. Or we need to make custom resolution(changing primary key by our own) for that. Or we should use GUID as a primary key for this.
