Mastering NServiceBus and Persistence

Chapter 6. SQL Server Examples

In this chapter, we will be focusing on snippets of SQL Server examples. We will discuss queuing in SQL Server. In addition to this, more advanced features of Entity Framework (EF), as well as MVC-EF examples will be discussed. This chapter is for developers who work with SQL Server and Entity Framework with NServiceBus.

In this chapter, we will cover the following topics:

• The SQL Server example
• The MVC-EF example
• Entity Framework snippets
• Creating tables through EF
  • Creating tables from the EF code-first
  • Creating tables from the EF model-first
• Expanding the code
• Unit testing

The SQL Server example

One of the many benefits of using SQL Server to persist sagas, timeouts, logging, and messages is that Visual Studio has many capabilities ...