SqlSyncProvider::ScopeName Property
Sets the name of the scope to synchronize, which is a logical group of tables with optional filters.
Assembly: Microsoft.Synchronization.Data.SqlServer (in Microsoft.Synchronization.Data.SqlServer.dll)
The following code example specifies the scope for a SqlSyncProvider object by using the DbSyncScopeDescription object, rather than setting ScopeName directly. To view this code in the context of a complete example, see How To: Execute Database Synchronization (SQL Server).
DbSyncScopeDescription scopeDesc = new DbSyncScopeDescription("filtered_customer"); // Definition for Customer. DbSyncTableDescription customerDescription = SqlSyncDescriptionBuilder.GetDescriptionForTable("Sales.Customer", serverConn); scopeDesc.Tables.Add(customerDescription); // Definition for CustomerContact, including the list of columns to include. Collection<string> columnsToInclude = new Collection<string>(); columnsToInclude.Add("CustomerId"); columnsToInclude.Add("PhoneType"); DbSyncTableDescription customerContactDescription = SqlSyncDescriptionBuilder.GetDescriptionForTable("Sales.CustomerContact", columnsToInclude, serverConn); scopeDesc.Tables.Add(customerContactDescription);
Dim scopeDesc As New DbSyncScopeDescription("filtered_customer") ' Definition for Customer. Dim customerDescription As DbSyncTableDescription = _ SqlSyncDescriptionBuilder.GetDescriptionForTable("Sales.Customer", serverConn) scopeDesc.Tables.Add(customerDescription) ' Definition for CustomerContact, including the list of columns to include. Dim columnsToInclude As New Collection(Of String)() columnsToInclude.Add("CustomerId") columnsToInclude.Add("PhoneType") Dim customerContactDescription As DbSyncTableDescription = _ SqlSyncDescriptionBuilder.GetDescriptionForTable("Sales.CustomerContact", columnsToInclude, serverConn) scopeDesc.Tables.Add(customerContactDescription)
Show: