O'Reilly logo

Mastering NServiceBus and Persistence by Rich Helton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The SQL queuing sample

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required