SqlSyncDescriptionBuilder 類別

表示與同步處理相關之 SQL Server 資料庫的範圍和資料表資訊。

命名空間: Microsoft.Synchronization.Data.SqlServer
組件: Microsoft.Synchronization.Data.SqlServer (在 microsoft.synchronization.data.sqlserver.dll)

語法

'宣告
Public NotInheritable Class SqlSyncDescriptionBuilder
'用途
The members of a static class are accessed directly without an instance of the class.

public static class SqlSyncDescriptionBuilder

public ref class SqlSyncDescriptionBuilder abstract sealed

public final class SqlSyncDescriptionBuilder

public final class SqlSyncDescriptionBuilder

範例

下列程式碼範例會描述名為 filtered_customer 的範圍，並將兩個資料表新增到此範圍：Customer 和 CustomerContact。資料表已經存在於伺服器資料庫中，所以會使用 GetDescriptionForTable 方法來擷取伺服器資料庫中的結構描述。雖然此範圍包含 Customer 資料表中的所有資料行，不過只包含 CustomerContact 資料表中的兩個資料行。若要在完整範例的內容中檢視這段程式碼，請參閱 HOW TO：設定及執行共同作業同步處理 (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)

繼承階層

System.Object
  Microsoft.Synchronization.Data.SqlServer.SqlSyncDescriptionBuilder

執行緒安全性

任何公用靜態 (共用 在 Visual Basic) 此型別的成員具備執行緒安全。不保證任何執行個體成員安全執行緒。

請參閱

參考

SqlSyncDescriptionBuilder 成員
Microsoft.Synchronization.Data.SqlServer 命名空間