Database Reference
In-Depth Information
Buyer's remorse code walkthrough
We will walk through the sample for NHibernate that is found at
https://github.com/Partic-
ular/NServiceBus.NHibernate.Samples
.
The reason that we keep choosing NHibernate for
now is its ability to work with many different database products, including SQL Server and
MySQL. We have also walked through a NHibernate example previously, so we are just
extending those fundamental concepts.
This example will use SQL Server to store subscriptions, sagas, and timeouts. It will be a
fictional video store with a web frontend, communicating with sagas and message handlers
as before.
First, we have an e-commerce endpoint implemented as an ASP.NET MVC4 application
that uses the following:
For Microsoft.AspNet.SignalR, see
http://www.asp.net/signalr
to know how to provide
feedback to the user. SignalR allows you to have bidirectional communication between the
server and client. ASP.NET MVC4 will provide a very generic home website to place or-
ders for NServiceBus videos.
The MVC application will send
MvcApplication.Bus.Send(command);
to the
bus with a command that contains the order information.
When the application starts, an
nservicebus
table is created with tables for
Con-
tainSagaData
for IBus to store specific data that contains
Id
,
Originator
, and
OriginalMessageId
we have discussed before.