SyncAdapter.SelectConflictDeletedRowsCommand 屬性

取得或設定用來識別與其他變更衝突之已刪除資料列的查詢或預存程序。

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

語法

'宣告
Public Property SelectConflictDeletedRowsCommand As IDbCommand
'用途
Dim instance As SyncAdapter
Dim value As IDbCommand

value = instance.SelectConflictDeletedRowsCommand

instance.SelectConflictDeletedRowsCommand = value

public IDbCommand SelectConflictDeletedRowsCommand { get; set; }

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

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

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

public function get SelectConflictDeletedRowsCommand () : IDbCommand

public function set SelectConflictDeletedRowsCommand (value : IDbCommand)

屬性值

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

備註

同步處理配接器命令可讓您指定，用來從伺服器資料庫選取及套用變更的查詢和預存程序。如需詳細資訊，請參閱 HOW TO：指定快照集、下載、上傳及雙向同步處理。您為 SelectConflictDeletedRowsCommand 指定的查詢或預存程序，會從伺服器資料庫的標記資料表中選取衝突的資料列。如果沒有在基底資料表中找到衝突的資料列，Sync Framework 會執行此命令。此命令會選取 ClientUpdateServerDelete 衝突的資料列。

範例

下列程式碼範例會建立一個命令，此命令會從 Customer_Tombstone 資料表選取衝突的資料列。若要在完整範例的內容中檢視這段程式碼，請參閱 HOW TO：處理資料衝突和錯誤。

SqlCommand customerDeleteConflicts = new SqlCommand();
customerDeleteConflicts.CommandText =
    "SELECT CustomerId, CustomerName, SalesPerson, CustomerType " +
    "FROM Sales.Customer_Tombstone " +
    "WHERE CustomerId = @CustomerId";
customerDeleteConflicts.Parameters.Add("@CustomerId", SqlDbType.UniqueIdentifier);
customerDeleteConflicts.Connection = serverConn;
customerSyncAdapter.SelectConflictDeletedRowsCommand = customerDeleteConflicts;

Dim customerDeleteConflicts As New SqlCommand()
With customerDeleteConflicts
    .CommandText = _
        "SELECT CustomerId, CustomerName, SalesPerson, CustomerType " _
      & "FROM Sales.Customer_Tombstone " + "WHERE CustomerId = @CustomerId"
    .Parameters.Add("@CustomerId", SqlDbType.UniqueIdentifier)
    .Connection = serverConn
End With
customerSyncAdapter.SelectConflictDeletedRowsCommand = customerDeleteConflicts

請參閱

參考

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