Hi Team,

I have some problem trying to sync to databases. I have entity with GUID as PK (no problem here) but this parent entity have subentity with PK Autoincrement, when I merge origin with destiny, some times ID between databases are no the same and I always do DELETE / INSERT instead of UPDATE, because the ID between subentity are not the same, and it's no possible to sync with ID, are different!!!

Please If possible to force PK (AUTOINCREMENT) when flag isNew on subentity?

Thanks

If I understand you correctly, you want to to insert rows from database A into database B and the table in database B has an autoincrement/identity PK so inserting the value from A wont' work, because you can't insert the value from A? (as it will autogenerated by B).

In SQL Server you can set a setting to ON https://learn.microsoft.com/en-us/sql/t-sql/statements/set-identity-insert-transact-sql?view=sql-server-ver16 which will then allow you to insert the values. However if your A and B databases go out of sync, it might be better to simply see B as a copy of A so B follows A, with a PK that's no autoincrement/identity? This might require a different entity model to work with database B however, as you can't switch identity inserts off in our framework at runtime.