background job support with sql azure

[bkolo]

allow for background jobs to be stored in SQL Azure in addition to SQLite

[bgiromini]

Yes, would love to just let it use whatever IDBConnectionFactory I use with the application

[mythz]

ServiceStack v8.9 now supports RDBMS Background Jobs - a new implementation with support for PostgreSQL, SQL Server and MySQL RDBMS backends.

The new DatabaseJobFeature is a new implementation purpose built for PostgreSQL, SQL Server and MySQL backends that's a drop-in replacement for SQLite's BackgroundsJobFeature which can be applied to an existing .NET 8+ project by mixing in the db-identity or db-jobs gist files to your host project.

Install

For ServiceStack ASP.NET Identity Auth Projects:

x mix db-identity

Which replaces Configure.BackgroundJobs.cs and Configure.RequestLogs.cs with an equivalent
version that uses the new DatabaseJobFeature for sending Application Emails and DbRequestLogger
for API Request Logging.

All other .NET 8+ ServiceStack Apps should instead use:

x mix db-jobs

Fortunately we were able reuse the same IBackgroundJobs interface, Data Models, and API Service Contracts
which greatly simplifies any migration efforts from SQLite's ServiceStack.Jobs implementation and lets us reuse the same
built-in Admin UIs.