SQL Server Transport Upgrade Version 3 to 4


TransactionScope transaction mode is not available in .NET Core 2.0 because the implementation of SqlConnection does not support enlisting in an ambient transaction.

To run the upgraded project on .NET Core the transport needs to be switched to one of the native transactions modes. Consider using the Outbox to maintain the same exactly-once processing guarantees.

Transaction scope is supposed to be supported by SqlConnection in future versions of .NET Core.

Multi-instance mode

The multi-instance mode has been deprecated in Version 4. So the following is no longer supported:

var transport = endpointConfiguration.UseTransport<SqlServerTransport>();
transport.EnableLegacyMultiInstanceMode(async address =>
    var connectionString = address.StartsWith("RemoteEndpoint")
        ? "Data Source=SQL; Database=RemoteEndpoint; Integrated Security=True"
        : "Data Source=SQL; Database=ThisEndpoint; Integrated Security=True";
    var connection = new SqlConnection(connectionString);
    await connection.OpenAsync()
    return connection;

NServiceBus topologies with queues distributed between multiple catalogs hosted in a single instance of SQL Server can now be configured using multi-catalog addressing:

var transport = endpointConfiguration.UseTransport<SqlServerTransport>();
transport.ConnectionString("Data Source=SQL; Database=ThisEndpoint; Integrated Security=True");
    endpointName: "RemoteEndpoint",
    catalog: "RemoteEndpoint");

If catalogs are hosted in different instances of SQL Server, use NServiceBus.Transport.Bridge to construct a bridge. The multi-instance sample demonstrates this approach.

Related Articles

Last modified