• Article

BusinessLogicModule.UpdateDeleteConflictHandler Method

Optional method that implements the custom business logic invoked when UPDATE statements conflict with DELETE statements at the Publisher and at the Subscriber.

Namespace:  Microsoft.SqlServer.Replication.BusinessLogicSupport
Assembly:  Microsoft.SqlServer.Replication.BusinessLogicSupport (in Microsoft.SqlServer.Replication.BusinessLogicSupport.dll)

Syntax

'Declaration
Public Overridable Function UpdateDeleteConflictHandler ( _
    updateSource As SourceIdentifier, _
    sourceDataSet As DataSet, _
    ByRef customDataSet As DataSet, _
    ByRef conflictLogType As ConflictLogType, _
    ByRef customConflictMessage As String, _
    ByRef historyLogLevel As Integer, _
    ByRef historyLogMessage As String _
) As ActionOnUpdateDeleteConflict
'Usage
Dim instance As BusinessLogicModule
Dim updateSource As SourceIdentifier
Dim sourceDataSet As DataSet
Dim customDataSet As DataSet
Dim conflictLogType As ConflictLogType
Dim customConflictMessage As String
Dim historyLogLevel As Integer
Dim historyLogMessage As String
Dim returnValue As ActionOnUpdateDeleteConflict

returnValue = instance.UpdateDeleteConflictHandler(updateSource, _
    sourceDataSet, customDataSet, conflictLogType, _
    customConflictMessage, historyLogLevel, _
    historyLogMessage)

public virtual ActionOnUpdateDeleteConflict UpdateDeleteConflictHandler(
    SourceIdentifier updateSource,
    DataSet sourceDataSet,
    ref DataSet customDataSet,
    ref ConflictLogType conflictLogType,
    ref string customConflictMessage,
    ref int historyLogLevel,
    ref string historyLogMessage
)

public:
virtual ActionOnUpdateDeleteConflict UpdateDeleteConflictHandler(
    SourceIdentifier updateSource, 
    DataSet^ sourceDataSet, 
    DataSet^% customDataSet, 
    ConflictLogType% conflictLogType, 
    String^% customConflictMessage, 
    int% historyLogLevel, 
    String^% historyLogMessage
)

abstract UpdateDeleteConflictHandler : 
        updateSource:SourceIdentifier * 
        sourceDataSet:DataSet * 
        customDataSet:DataSet byref * 
        conflictLogType:ConflictLogType byref * 
        customConflictMessage:string byref * 
        historyLogLevel:int byref * 
        historyLogMessage:string byref -> ActionOnUpdateDeleteConflict 
override UpdateDeleteConflictHandler : 
        updateSource:SourceIdentifier * 
        sourceDataSet:DataSet * 
        customDataSet:DataSet byref * 
        conflictLogType:ConflictLogType byref * 
        customConflictMessage:string byref * 
        historyLogLevel:int byref * 
        historyLogMessage:string byref -> ActionOnUpdateDeleteConflict 

public function UpdateDeleteConflictHandler(
    updateSource : SourceIdentifier, 
    sourceDataSet : DataSet, 
    customDataSet : DataSet, 
    conflictLogType : ConflictLogType, 
    customConflictMessage : String, 
    historyLogLevel : int, 
    historyLogMessage : String
) : ActionOnUpdateDeleteConflict

Parameters

  • sourceDataSet
    Type: System.Data.DataSet
    Dataset that contains the GUID representing the row in conflict.
  • customConflictMessage
    Type: System.String%
    Conflict message returned by the custom business logic handler.
  • historyLogLevel
    Type: System.Int32%
    Log level of the custom message returned by the custom business logic handler.
  • historyLogMessage
    Type: System.String%
    Log message provided by custom business logic handler. The log message gets written to the distribution database.

Return Value

Type: Microsoft.SqlServer.Replication.BusinessLogicSupport.ActionOnUpdateDeleteConflict
The ActionOnUpdateDeleteConflict action that will be taken by the process after the custom business logic handler has executed.