From these frameworks and the use of SQL Queuing, we will be introducing a PayQueue sample that will be evolving over some of the following chapters.
The solution will start with four projects:
MyMessages
: This contains the common messages—currentlyEventMessage
given previouslyAppForWritingXML
: This contains the application to write XML messages to diskAppForWritingTables
: This contains Entity Framework and C# refection to populate the PayQueuePayments
table with the event message dataAppForReadingXML
: This reads the sample XML files from disk, populates thePayments
table, and sends the data through a SQL Queue
Many of the snippets have already been covered in part. The part that remains is sending it across the bus in SQL Queuing. We set the logging (log4net in this case), configure the bus, and send the message.
The installation piece creates the endpoints in SQL Server, and it knows to do this because the transport is set to <SqlServer>
:
// Set the...