Simple SQL Server transport usage

Component: SQL Server Transport
NuGet Package NServiceBus.Transport.SqlServer (6.x)
Target NServiceBus Version: 7.x

Prerequisites

An instance of SQL Server Express, accessible as .\SqlExpress.

At startup, each endpoint creates its required SQL assets, including databases, tables, and schemas.

The sample creates a database named SQLServerSimple.

Running the sample

  1. Start both the Sender and Receiver projects.
  2. Press c to send a command, or e to publish an event, from Sender to Receiver.
  3. Receiver handles the message in the matching handler.

Code walk-through

Configuring the SQL Server transport

var transport = endpointConfiguration.UseTransport<SqlServerTransport>();
var connection = @"Data Source=.\SqlExpress;Database=SqlServerSimple;Integrated Security=True;Max Pool Size=100";
transport.ConnectionString(connection);
transport.Routing().RouteToEndpoint(typeof(MyCommand), "Samples.SqlServer.SimpleReceiver");

Related Articles


Last modified