SqlCeSyncScopeProvisioning.Apply Method
Applies the provisioning script over the connection that was specified in the constructor.
Assembly: Microsoft.Synchronization.Data.SqlServerCe (in Microsoft.Synchronization.Data.SqlServerCe.dll)
The following example shows how to define a filtered scope that includes only items from the Sales.Customer table that have a CustomerType value of Retail. The filtered scope is then used to provision a SQL Azure database and a SQL Server Compact client database for filtered synchronization.
SqlSyncScopeProvisioning azureRetailCustomersScope = new SqlSyncScopeProvisioning(azureConn); azureRetailCustomersScope.PopulateFromTemplate("RetailCustomers", "customertype_template"); azureRetailCustomersScope.Tables["Sales.Customer"].FilterParameters["@customertype"].Value = "Retail"; azureRetailCustomersScope.UserComment = "Customer data includes only retail customers."; azureRetailCustomersScope.Apply(); // Create a SQL Server Compact database and provision it based on the retail customer scope // retrieved from the SQL Azure database. SqlCeConnection clientSqlCeConn = new SqlCeConnection(Utility.ConnStr_SqlCeSync1); Utility.DeleteAndRecreateCompactDatabase(Utility.ConnStr_SqlCeSync1, true); DbSyncScopeDescription azureRetailCustomersDesc = SqlSyncDescriptionBuilder.GetDescriptionForScope("RetailCustomers", azureConn); SqlCeSyncScopeProvisioning clientSqlCeConfig = new SqlCeSyncScopeProvisioning(clientSqlCeConn, azureRetailCustomersDesc); clientSqlCeConfig.Apply();
Dim azureRetailCustomersScope As New SqlSyncScopeProvisioning(azureConn) azureRetailCustomersScope.PopulateFromTemplate("RetailCustomers", "customertype_template") azureRetailCustomersScope.Tables("Sales.Customer").FilterParameters("@customertype").Value = "Retail" azureRetailCustomersScope.UserComment = "Customer data includes only retail customers." azureRetailCustomersScope.Apply() ' Create a SQL Server Compact database and provision it based on the retail customer scope ' retrieved from the SQL Azure database. Dim clientSqlCeConn As New SqlCeConnection(Utility.ConnStr_SqlCeSync1) Utility.DeleteAndRecreateCompactDatabase(Utility.ConnStr_SqlCeSync1, True) Dim azureRetailCustomersDesc As DbSyncScopeDescription = SqlSyncDescriptionBuilder.GetDescriptionForScope("RetailCustomers", azureConn) Dim clientSqlCeConfig As New SqlCeSyncScopeProvisioning(clientSqlCeConn, azureRetailCustomersDesc) clientSqlCeConfig.Apply()
Show: