DistributionDatabase.RegisterBusinessLogicHandler 方法

定義

命名空間:
Microsoft.SqlServer.Replication
組件:
Microsoft.SqlServer.Rmo.dll

在分發器註冊一個商業邏輯處理器組件。

public:
 void RegisterBusinessLogicHandler(Microsoft::SqlServer::Replication::BusinessLogicHandler ^ businessLogicHandler);
public void RegisterBusinessLogicHandler(Microsoft.SqlServer.Replication.BusinessLogicHandler businessLogicHandler);
member this.RegisterBusinessLogicHandler : Microsoft.SqlServer.Replication.BusinessLogicHandler -> unit
Public Sub RegisterBusinessLogicHandler (businessLogicHandler As BusinessLogicHandler)

參數

businessLogicHandler
BusinessLogicHandler

一個 BusinessLogicHandler 代表被註冊的商業邏輯處理器的物件。

範例

// Specify the Distributor name and business logic properties.
string distributorName = publisherInstance;
string assemblyName = @"C:\Program Files\Microsoft SQL Server\110\COM\CustomLogic.dll";
string className = "Microsoft.Samples.SqlServer.BusinessLogicHandler.OrderEntryBusinessLogicHandler";
string friendlyName = "OrderEntryLogic";

ReplicationServer distributor;
BusinessLogicHandler customLogic;

    // Create a connection to the Distributor.
ServerConnection distributorConn = new ServerConnection(distributorName);

try
{
    // Connect to the Distributor.
    distributorConn.Connect();

    // Set the Distributor properties.
    distributor = new ReplicationServer(distributorConn);

    // Set the business logic handler properties.
    customLogic = new BusinessLogicHandler();
    customLogic.DotNetAssemblyName = assemblyName;
    customLogic.DotNetClassName = className;
    customLogic.FriendlyName = friendlyName;
    customLogic.IsDotNetAssembly = true;

    Boolean isRegistered = false;

    // Check if the business logic handler is already registered at the Distributor.
    foreach (BusinessLogicHandler registeredLogic
        in distributor.EnumBusinessLogicHandlers())
    {
        if (registeredLogic == customLogic)
        {
            isRegistered = true;
        }
    }

    // Register the custom logic.
    if (!isRegistered)
    {
        distributor.RegisterBusinessLogicHandler(customLogic);
    }
}
catch (Exception ex)
{
    // Do error handling here.
    throw new ApplicationException(string.Format(
        "The {0} assembly could not be registered.",
        assemblyName), ex);
}
finally
{
    distributorConn.Disconnect();
}

' Specify the Distributor name and business logic properties.
Dim distributorName As String = publisherInstance
Dim assemblyName As String = "C:\Program Files\Microsoft SQL Server\110\COM\CustomLogic.dll"
Dim className As String = "Microsoft.Samples.SqlServer.BusinessLogicHandler.OrderEntryBusinessLogicHandler"
Dim friendlyName As String = "OrderEntryLogic"

Dim distributor As ReplicationServer
Dim customLogic As BusinessLogicHandler

' Create a connection to the Distributor.
Dim distributorConn As ServerConnection = New ServerConnection(distributorName)

Try
    ' Connect to the Distributor.
    distributorConn.Connect()

    ' Set the Distributor properties.
    distributor = New ReplicationServer(distributorConn)

    ' Set the business logic handler properties.
    customLogic = New BusinessLogicHandler()
    customLogic.DotNetAssemblyName = assemblyName
    customLogic.DotNetClassName = className
    customLogic.FriendlyName = friendlyName
    customLogic.IsDotNetAssembly = True

    Dim isRegistered As Boolean = False

    ' Check if the business logic handler is already registered at the Distributor.
    For Each registeredLogic As BusinessLogicHandler _
    In distributor.EnumBusinessLogicHandlers
        If registeredLogic Is customLogic Then
            isRegistered = True
        End If
    Next

    ' Register the custom logic.
    If Not isRegistered Then
        distributor.RegisterBusinessLogicHandler(customLogic)
    End If
Catch ex As Exception
    ' Do error handling here.
    Throw New ApplicationException(String.Format( _
     "The {0} assembly could not be registered.", _
     assemblyName), ex)
Finally
    distributorConn.Disconnect()
End Try

備註

商業邏輯處理器必須在發行商註冊（若是拉取訂閱則在訂閱者）註冊。 然而，實作商業邏輯處理器的組合語言只需安裝在執行 合併代理程式 的伺服器上即可。

<xref:Microsoft.SqlServer.Replication.ReplicationServer.RegisterBusinessLogicHandler%2A>此方法只能由固定sysadmin伺服器角色的成員及固定資料庫角色的成員db_owner呼叫

呼叫 <xref:Microsoft.SqlServer.Replication.ReplicationServer.RegisterBusinessLogicHandler%2A> 等同於執行 sp_registercustomresolver。

適用於

另請參閱