在Sync Framework 2.1中同步相对表
|
我正在尝试在Sync Framework 2.1的帮助下将Sql Express 2008与Sql Compact 3.5同步
我有2张桌子
客户（PK ID，字符串名称）
订单（PK ID，int价格，字符串
名称（FK Customer_Id）
我使用以下代码
public static void CreateScope(string userName)
{
var serverConn = new SqlConnection(@\"Data Source=.\\SQLEXPRESS; Initial Catalog=Test; Integrated Security=True\");
var scopeDescription = new DbSyncScopeDescription(string.Format(\"Customer-{0}\", userID));
var customersTable = SqlSyncDescriptionBuilder.GetDescriptionForTable(\"Customers\", serverConn);
var ordersTable = SqlSyncDescriptionBuilder.GetDescriptionForTable(\"Orders\", serverConn);
ordersTable.Constraints.Add(\"FK_Customer_Id\", \"Customers\", \"Orders\", \"Id\", \"Customer_Id\");
scopeDesc.Tables.Add(azmanotTable);
scopeDesc.Tables.Add(customersTable);
var serverProvision = new SqlSyncScopeProvisioning(serverConn, scopeDesc);
serverProvision.SetCreateTableDefault(DbSyncCreationOption.Skip);
serverProvision.Tables[\"Customers\"].AddFilterColumn(\"CustumerName\");
serverProvision.Tables[\"Customers\"].FilterClause = string.Format(\"[side].[CustumerName] = \'{0}\'\", userName);
serverProvision.Apply();
}
没有找到相关结果
已邀请:
1 个回复
扫窟
serverProvision.Tables[\"Orders\"].AddFilterColumn(\"CustomerId\"); serverProvision.Tables[\"Customers\"].FilterClause = string.Format(\"[side].[CustomerId] in (Select CustomerId from Customers_tracking where CustomerName = \'{0}\'\", userName);