SQL

PM> Install-Package Shuttle.Esb.Sql.Queue

Sql RDBMS implementation of the IQueue interface for use with Shuttle.Esb which creates a table for each required queue.

Supported providers

Currently only the Microsoft.Data.SqlClient provider name is supported.able.

Configuration

TThe URI structure is sql://configuration-name/queue-name.

services.AddDataAccess(builder =>
{
	builder.AddConnectionString("shuttle", "Microsoft.Data.SqlClient", "server=.;database=shuttle;user id=sa;password=Pass!000");
});

services.AddSqlQueue(builder =>
{
	builder.AddOptions("shuttle", new SqlQueueOptions
	{
		ConnectionStringName = "shuttle"
	});
});

The default JSON settings structure is as follows:

{
  "Shuttle": {
    "SqlQueue": {
      "ConnectionStringName": "connection-string-name"
    }
  }
}

Options

Option	Default	Description
ConnectionStringName		The name of the connection string to use. This package makes use of Shuttle.Core.Data for data access.