问同步框架-无法更新或删除主键表。仅插入工作

EN

DbSyncScopeDescription scopeDesc = new DbSyncScopeDescription("Name");

scopeDesc.Tables.Add(SqlSyncDescriptionBuilder.GetDescriptionForTable("ParentTable", sqlSourceConn));
scopeDesc.Tables.Add(SqlSyncDescriptionBuilder.GetDescriptionForTable("ChildTable", sqlSourceConn));


var sqlSourceProv = new SqlSyncScopeProvisioning(sqlSourceConn, scopeDesc);
sqlSourceProv.CommandTimeout = 3600;
if (!sqlSourceProv.ScopeExists("Name"))
   sqlSourceProv.Apply();

var sqlDestinationProv = new SqlSyncScopeProvisioning(sqlDestinationConn, scopeDesc);
sqlDestinationProv.CommandTimeout = 3600;
if (!sqlDestinationProv.ScopeExists("Name"))
   sqlDestinationProv.Apply();

var destinationProvider = new SqlSyncProvider("Name", sqlDestinationConn);

var sourceProvider = new SqlSyncProvider("Name", sqlSourceConn);

destinationProvider.MemoryDataCacheSize = MemorySize;
sourceProvider.MemoryDataCacheSize = MemorySize;

destinationProvider.ApplicationTransactionSize = BatchSize;

SyncOrchestrator orch = new SyncOrchestrator();
orch.RemoteProvider = destinationProvider;
orch.LocalProvider = sourceProvider;
orch.Direction = SyncDirectionOrder.Upload;

SyncOperationStatistics stats = orch.Synchronize();