MassTransit with SQL Server Database Transport

Question

For my client we're investigating the use of MassTransit. MassTransit seems to be focussed around RabbitMQ as for message transport. Due 'intrastructural constraints' of the client, we're stuck with using SQL Server database as any persistence.

How can MassTransport be used with SQL Server as transport mechanism for messages?

Answer 1

SQL Server is not a transport, it only stores messages. Without a broker, there's no way to get MassTransit to work. With older MassTransit (2.x) you could use Subscription Service to replace the broker, but it requires some additional infrastructure.

Using Azure/Windows Service Bus would be a better solution as it's a real broker. You don't have to use RabbitMQ.