The SQL Persistence uses Json.NET to serialize data and store in a SQL database.
The SQL Persistence consists of several Nuget Packages.
This packages installs into the MSBuild pipeline and generates all SQL installation scripts at compile time. It does this by interrogating types (in the target assembly) and attributes (from the
NServiceBus. NuGet package) to infer what scripts to create. It is required for any project where those SQL installation scripts are required. For Saga scripts it will be any project that contains Saga classes. For Timeouts, Subscriptions and Outbox scripts it will be the endpoint hosting project. This package has a dependency on the
NServiceBus. NuGet package
This package contains several parts
- APIs for manipulating
EndPointConfigurationat configuration time.
- Runtime implementations of Saga, Timeouts, Subscriptions and Outbox persisters.
- Attribute definitions used to define certain compile time configuration settings. These attributes are then interrogated by the NServiceBus.Persistence.Sql.MsBuild NuGet Package when generating SQL installation scripts
- Optionally runs SQL installation scripts at endpoint startup for development purposes. See Installer Workflow.
This package contains all APIs that enable the generation of SQL installation scripts using code, i.e. without using the NServiceBus.Persistence.Sql.MsBuild NuGet package.
SQL installation scripts are created at compile time by the
NServiceBus. NuGet package. To learn more see controlling script generation.