首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >同步框架-添加FilterClause后删除不起作用

同步框架-添加FilterClause后删除不起作用
EN

Stack Overflow用户
提问于 2012-06-01 07:41:15
回答 1查看 570关注 0票数 0

添加FilterClause后,delete不再起作用。

JuneT说filter on tracking table which is Users_tracking

但是,我在Users_tracking中看不到IsPublished列;我只看到UserId。

谢谢你的帮助!

代码语言:javascript
运行
复制
private static void ProvisionLocal(
   SqlConnection sqlLocalConn, DbSyncScopeDescription scopeDesc)
{
   var Users = SqlSyncDescriptionBuilder
     .GetDescriptionForTable("Users", sqlLocalConn);

   scopeDesc.Tables.Add(Users);

   var sqlLocalProv = new SqlSyncScopeProvisioning(sqlLocalConn, scopeDesc);
   sqlLocalProv.CommandTimeout = 3600;

   sqlLocalProv.Tables["Users"].AddFilterColumn("IsPublished");
   sqlLocalProv.Tables["Users"].FilterClause = 
      string.Format("[side].[IsPublished] = {0}", 1);

   if (!sqlLocalProv.ScopeExists("TestScope"))
   {
     sqlLocalProv.Apply();
   }
}

private static void ProvisionRemote( 
   SqlConnection sqlRemoteConn, DbSyncScopeDescription scopeDesc)
{
   var sqlRemoteProv = new SqlSyncScopeProvisioning(sqlRemoteConn, scopeDesc);
   sqlRemoteProv.CommandTimeout = 3600;

   if (!sqlRemoteProv.ScopeExists("TestScope"))
   {
     // Apply the scope provisioning.
     sqlRemoteProv.Apply();
   }
}

public void Synchronize()
{    
   var sqlSourceConn = new SqlConnection("...");
   var sqlDestinationConn = new SqlConnection("...");

   var scopeDesc = new DbSyncScopeDescription("TestScope");

   ProvisionLocal(type, sqlSourceConn, scopeDesc);
   ProvisionRemote(type, sqlDestinationConn, scopeDesc);

   // Prepare for synchronization
   var localProvider = new SqlSyncProvider("TestScope", sqlSourceConn);

   var remoteProvider = new SqlSyncProvider("TestScope", sqlDestinationConn);
   remoteProvider.ApplyChangeFailed += RemoteProvider_ApplyChangeFailed;

   var orch = new SyncOrchestrator();
   orch.RemoteProvider = remoteProvider;
   orch.LocalProvider = localProvider;
   orch.Direction = SyncDirectionOrder.Upload;

   SyncOperationStatistics stats = orch.Synchronize();

   sqlDestinationConn.Close();
   sqlSourceConn.Close();
}

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2012-06-01 07:57:10

IsPublished列位于跟踪表的底部...

您的表是否属于另一个作用域?您是否正在添加另一个作用域?

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/10842703

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档