110,539
社区成员
发帖
与我相关
我的任务
分享
SqlSyncAdapterBuilder builderCustomerPhone = new SqlSyncAdapterBuilder((SqlConnection)serverSybcOrivuder.Connection);
builderCustomerPhone.TableName = "dbo.CustomerPhone";
builderCustomerPhone.SyncDirection = SyncDirection.Snapshot;
builderCustomerPhone.DataColumns.Add("CustomerId");
builderCustomerPhone.DataColumns.Add("CustomerName");
builderCustomerPhone.DataColumns.Add("PhoneNumber");
builderCustomerPhone.DataColumns.Add("PhoneType");
builderCustomerPhone.FilterClause = "PhoneNumber <> ''";
SyncAdapter customerPhoneSyncAdapter = builderCustomerPhone.ToSyncAdapter();
customerPhoneSyncAdapter.TableName = "CustomerPhone";
serverSybcOrivuder.SyncAdapters.Add(customerPhoneSyncAdapter);
SyncTable customerPhoneSyncTable = new SyncTable("CustomerPhone");
customerPhoneSyncTable.CreationOption = TableCreationOption.DropExistingOrCreateNewTable;
customerPhoneSyncTable.SyncDirection = SyncDirection.Snapshot;
syncAgent.Configuration.SyncTables.Add(customerPhoneSyncTable);