DbSyncProvider.SelectOverlappingScopesCommand 屬性

取得或設定 IDbCommand 物件，此物件包含針對指定之範圍內的所有資料表 (同時包含在其他範圍內) 傳回範圍名稱和資料表名稱的查詢或預存程序。

此屬性與 CLS 不相容。  

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

語法

'宣告
Public Overridable Property SelectOverlappingScopesCommand As IDbCommand
'用途
Dim instance As DbSyncProvider
Dim value As IDbCommand

value = instance.SelectOverlappingScopesCommand

instance.SelectOverlappingScopesCommand = value

public virtual IDbCommand SelectOverlappingScopesCommand { get; set; }

public:
virtual property IDbCommand^ SelectOverlappingScopesCommand {
    IDbCommand^ get ();
    void set (IDbCommand^ value);
}

/** @property */
public IDbCommand get_SelectOverlappingScopesCommand ()

/** @property */
public void set_SelectOverlappingScopesCommand (IDbCommand value)

public function get SelectOverlappingScopesCommand () : IDbCommand

public function set SelectOverlappingScopesCommand (value : IDbCommand)

屬性值

包含查詢或預存程序的 IDbCommand 物件。

範例

下列程式碼範例會指定 SelectOverlappingScopesCommand 屬性的命令。這個命令以及針對 UpdateScopeCleanupTimestampCommand 屬性指定的命令會讓 Sync Framework 在資料表包含於一個以上之範圍的情況下適當處理清除動作。若要在完整範例的內容中檢視這段程式碼，請參閱 HOW TO：清除共同作業同步處理的中繼資料 (非 SQL Server)。

SqlCommand overlappingScopesCmd = new SqlCommand();
overlappingScopesCmd.CommandType = CommandType.StoredProcedure;
overlappingScopesCmd.CommandText = "Sync.sp_SelectSharedScopes";
overlappingScopesCmd.Parameters.Add("@" + DbSyncSession.SyncScopeName, SqlDbType.NVarChar, 100);
sampleDbProvider.SelectOverlappingScopesCommand = overlappingScopesCmd;

Dim overlappingScopesCmd As New SqlCommand()
With overlappingScopesCmd
    .CommandType = CommandType.StoredProcedure
    .CommandText = "Sync.sp_SelectSharedScopes"
    .Parameters.Add("@" + DbSyncSession.SyncScopeName, SqlDbType.NVarChar, 100)
End With

sampleDbProvider.SelectOverlappingScopesCommand = overlappingScopesCmd

下列程式碼範例會建立由重疊範圍命令所呼叫的預存程序。

CREATE PROCEDURE Sync.sp_SelectSharedScopes
      @sync_scope_name nvarchar(100)      
AS
   SELECT ScopeTableMap2.table_name AS sync_table_name, 
          ScopeTableMap2.scope_name AS sync_shared_scope_name
   FROM Sync.ScopeTableMap ScopeTableMap1 JOIN Sync.ScopeTableMap ScopeTableMap2
   ON ScopeTableMap1.table_name = ScopeTableMap2.table_name
   AND ScopeTableMap1.scope_name = @sync_scope_name
   WHERE ScopeTableMap2.scope_name <> @sync_scope_name

請參閱

參考

DbSyncProvider 類別
DbSyncProvider 成員
Microsoft.Synchronization.Data 命名空間