We have already explored MSMQ in previous chapters. Wouldn't it be nice to store the messages in MySQL or SQL Server instead, and not worry so much about tooling for MSMQ if the database is already tooled? Also, you can consolidate all the data into a database, thus not having multiple products to maintain. MSMQ is a product, and makes more used of database tools for these programs.

In this section, we will be using NserviceBus.SqlServer.Samples-master\VideoStore.SqlServer, which is described in the SQL Queuing sample. The sample runs a video store for SQL queuing to order videos.

The solution was run in VS 2012 in Windows Server 2012, with MSMQ, DTC, NServiceBus references, and SQL Server 2012 Express LocalDB installed.

Running the example, https://github.com/Particular/NServiceBus.SqlServer.Samples, we see that the queues are now created in the nservicebus table instead of the MSMQ.

We can see that the audit message queue in SQL Server is filling up with messages; this...