Prerequisites
An instance of SQL Server Express installed and accessible as .
.
At startup each endpoint will create its required SQL assets including databases, tables, and schemas.
The database created by this sample is called SQLServerSimple
.
Running the project
- Start both the Sender and Receiver projects.
- Press c to send a command, or e to publish an event to the receiver endpoint.
- The receiver endpoint will handle the messages in the matching handler.
Code walk-through
Configure the SQL Server transport
var connection = @"Data Source=.\SqlExpress;Database=SqlServerSimple;Integrated Security=True;Max Pool Size=100";
var routing = endpointConfiguration.UseTransport(new SqlServerTransport(connection)
{
TransportTransactionMode = TransportTransactionMode.SendsAtomicWithReceive
});
routing.RouteToEndpoint(typeof(MyCommand), "Samples.SqlServer.SimpleReceiver");