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);

            SqlSyncScopeProvisioning serverConfig = new SqlSyncScopeProvisioning(serverConn, scopeDesc);
            serverConfig.ObjectSchema = "Sync";

            // Specify which column(s) in the Customer table to use for filtering data, 
            // and the filtering clause to use against the tracking table.
            // "[side]" is an alias for the tracking table.
            serverConfig.Tables["Sales.Customer"].AddFilterColumn("CustomerType");
            serverConfig.Tables["Sales.Customer"].FilterClause = "[side].[CustomerType] = 'Retail'";

            // Configure the scope and change-tracking infrastructure.
            serverConfig.Apply();

            // Write the configuration script to a file. You can modify 
            // this script if necessary and run it against the server
            // to customize behavior.
            File.WriteAllText("SampleConfigScript.txt", serverConfig.Script());

            // 創(chuàng)建一個SQL Server Compact數(shù)據(jù)庫并用從服務(wù)器端獲取的作用域信息來設(shè)置它
            // Compact數(shù)據(jù)庫不支持單獨的schema，
            // 所以我們通過為所有的同步對象增加前綴"Sync"來使他們易于區(qū)分
            Utility.DeleteAndRecreateCompactDatabase(Utility.ConnStr_SqlCeSync1, true);
            Utility.DeleteAndRecreateCompactDatabase(Utility.ConnStr_SqlCeSync2, false);
            DbSyncScopeDescription clientSqlCe1Desc = SqlSyncDescriptionBuilder.GetDescriptionForScope("filtered_customer", null, "Sync", serverConn);
            SqlCeSyncScopeProvisioning clientSqlCe1Config = new SqlCeSyncScopeProvisioning(clientSqlCe1Conn, clientSqlCe1Desc);
            clientSqlCe1Config.ObjectPrefix = "Sync";
            clientSqlCe1Config.Apply();

            // 通過從SQL Server Compact數(shù)據(jù)庫中獲取的同步作用域信息來設(shè)置一個SQL Server客戶端數(shù)據(jù)庫
            // 當(dāng)然我們也可以從服務(wù)器端獲取作用域信息
            DbSyncScopeDescription clientSqlDesc = SqlCeSyncDescriptionBuilder.GetDescriptionForScope("filtered_customer", "Sync", clientSqlCe1Conn);
            SqlSyncScopeProvisioning clientSqlConfig = new SqlSyncScopeProvisioning(clientSqlConn, clientSqlDesc);
            clientSqlConfig.ObjectSchema = "Sync";
            clientSqlConfig.Apply();

            // 在SQL Server客戶端數(shù)據(jù)庫中刪除RetailCustomers作用域
            SqlSyncScopeDeprovisioning clientSqlDepro = new SqlSyncScopeDeprovisioning(clientSqlConn);

            // 首先把取消設(shè)置的SQL腳本保存下來，以便取消設(shè)置其他的SQL Server客戶端數(shù)據(jù)庫
            // 這一步是可選的
            File.WriteAllText("SampleDeprovisionScript.txt",
                clientSqlDepro.ScriptDeprovisionScope("RetailCustomers"));

            // 刪除作用域
            clientSqlDepro.DeprovisionScope("RetailCustomers");

-- Find all filtered scopes that were created from the filtered scope template named 'customertype_template'.

select sync_scope_name from scope_info 
      where scope_config_id = 
      (select template_config_id from scope_templates 
            where template_name = N'customertype_template')

            // 從服務(wù)器數(shù)據(jù)庫中刪除"customertype_template"模板
            // 這樣也會刪除所有依賴與該模板的作用域
            SqlSyncScopeDeprovisioning serverSqlDepro = new SqlSyncScopeDeprovisioning(serverConn);
            serverSqlDepro.DeprovisionTemplate("customertype_template");

            // 在SQL Server Compact數(shù)據(jù)庫這哦你刪除所有的同步對象
            SqlCeSyncScopeDeprovisioning clientSqlCeDepro = new SqlCeSyncScopeDeprovisioning(clientSqlCe1Conn);
            clientSqlCeDepro.DeprovisionStore();

        static void SynchronizationUsingSnapshot()
        {
            // 通過從服務(wù)器數(shù)據(jù)庫獲取的作用域信息來設(shè)置Compact數(shù)據(jù)庫SyncCompactDB2.sdf
            SqlCeConnection clientConn = new SqlCeConnection(@"Data Source='D:\Sync Framework\CompactDB\SyncCompactDB2.sdf'");
            SqlConnection serverConn = new SqlConnection("Data Source=localhost; Initial Catalog=SyncDB; Integrated Security=True");
            DbSyncScopeDescription scopeDesc = SqlSyncDescriptionBuilder.GetDescriptionForScope("ProductsScope", serverConn);
            SqlCeSyncScopeProvisioning clientProvision = new SqlCeSyncScopeProvisioning(clientConn, scopeDesc);
            clientProvision.Apply();

            // 從SQL Server Compact數(shù)據(jù)庫創(chuàng)建一個快照，該快照將用于初始化其他的Compact數(shù)據(jù)庫
            // 盡管我們可以從其他數(shù)據(jù)庫獲取作用域信息來初始化，但快照的使用為Compact數(shù)據(jù)庫提供了一個更加快捷方便的部署方案。
            // SyncCompactDB3.sdf為不存在的Compact數(shù)據(jù)庫，將在GenerateSnapshot方法中自動創(chuàng)建
            string newCompactDB = @"D:\Sync Framework\CompactDB\SyncCompactDB3.sdf";
            SqlCeSyncStoreSnapshotInitialization syncStoreSnapshot = new SqlCeSyncStoreSnapshotInitialization();
            syncStoreSnapshot.GenerateSnapshot(clientConn, newCompactDB);

            // 對使用快照初始化的SyncCompactDB3.sdf執(zhí)行同步,因為快照中已經(jīng)包含了服務(wù)器中的數(shù)據(jù)
            // 所以本次同步將沒有數(shù)據(jù)被同步，直到一方的數(shù)據(jù)發(fā)生變化
            SyncOrchestrator syncOrchestrator = new SyncOrchestrator();
            syncOrchestrator.LocalProvider = new SqlCeSyncProvider("ProductsScope", clientConn);
            syncOrchestrator.RemoteProvider = new SqlSyncProvider("ProductsScope", serverConn);
            syncOrchestrator.Direction = SyncDirectionOrder.UploadAndDownload;
            SyncOperationStatistics syncStats = syncOrchestrator.Synchronize();
            DisplayStats(syncStats);
        }

        static void DisplayStats(SyncOperationStatistics syncStats)
        {
            // 輸出統(tǒng)計數(shù)據(jù)
            Console.WriteLine("Start Time: " + syncStats.SyncStartTime);
            Console.WriteLine("Total Changes Uploaded: " + syncStats.UploadChangesTotal);
            Console.WriteLine("Total Changes Downloaded: " + syncStats.DownloadChangesTotal);
            Console.WriteLine("Complete Time: " + syncStats.SyncEndTime);
            Console.WriteLine(String.Empty);
        }