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

• updateSource
  Type: Microsoft.SqlServer.Replication.BusinessLogicSupport.SourceIdentifier
  Is the SourceIdentifier that indicates whether the source of the update is the Publisher or the Subscriber.

• sourceDataSet
  Type: System.Data.DataSet
  Dataset that contains the GUID representing the row in conflict.

• customDataSet
  Type: System.Data.DataSet%
  Dataset implemented by the custom business logic.

• conflictLogType
  Type: Microsoft.SqlServer.Replication.BusinessLogicSupport.ConflictLogType%
  ConflictLogType requested by the custom business logic handler.

• 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.

See Also

Reference

BusinessLogicModule Class

Microsoft.SqlServer.Replication.BusinessLogicSupport Namespace

Other Resources

Execute Business Logic During Merge Synchronization

Implement a Business Logic Handler for a Merge Article