Stores NServiceBus data in various relational database engines, without the need for an intermediate ORM, using only a configured
For a description of each feature, see the persistence at a glance legend.
|Storage Types||Sagas, Outbox, Subscriptions, Timeouts|
|Transactions||Local database transactions or distributed transactions when available|
|Concurrency control||Optimistic concurrency for correctness + pessimistic concurrency for performance|
|Scripted deployment||SQL scripts generated at compile time, can be promoted outside build directory.|
|Installers||Installers execute the generated scripts, which can be enabled in development.|
- Supports multiple database engines.
- No ORM dependency: can be used with Entity Framework, Dapper, etc.
- Independent tables for each endpoint. No "noisy neighbor" problems.
- Generates DDL scripts at compile time in the build output directory.
- Generated scripts can be promoted outside the build directory and:
- Added to source control.
- Compared using a diff viewer.
- Inspected by DBAs.
- Treated as first-class citizens in operations workflows for installation and deployment.
- Sagas are:
The SQL Persister requires the NServiceBus.Persistence.Sql package, which contains:
- APIs for manipulating
- Runtime implementations of saga, timeouts, subscriptions, and outbox persisters.
- Attributes used to define compile-time configuration settings.
- [Version 4.3+] An MSBuild target that generates the required SQL installation scripts at compile time.
- Optionally runs SQL installation scripts at endpoint startup for development purposes. See Installer Workflow.
- NServiceBus.Persistence.Sql.MsBuild - In version 4.2 and below, this package must also be referenced to generate scripts. In version 4.3 and above, this package is deprecated, as the generation capability is built in to the main package.
- NServiceBus.Persistence.Sql.ScriptBuilder - This package contains the APIs that enable the generation of SQL installation scripts using code outside of a compile context. It is not intended for general usage, and in future releases, the API may evolve in ways that do not follow semantic versioning.
SQL installation scripts are created as a compile-time output alongside a project's binary outputs. Additionally, these scripts can be promoted to a directory under source control so that differences can be easily tracked and analyzed. To learn more, see Controlling Script Generation.
SqlPersistenceTask: Looping & branching statements are not allowed in a ConfigureHowToFindSaga method.
ConfigureHowToFindSaga method can only contain statements that invoke
ConfigureMapping. Check if there is a null check or if the calling of
ConfigureHowToFindSaga was done via the
?. Null-conditional operator and remove the ‘?.’ operator when present as the mapper will never be null.