Quartz.Net 2.0 Database Providers

Quartz.Net supports quite a few different database providers. This information is embedded inside the Quartz.dll file, but I think it is useful to have it handy. I’ve created a table with the names of all the (as of now) supported database providers. If you would like the full details on the providers, take a look at the dbproviders.properties file.

Here is a summary of all the supported providers along with the key name that you will need to use in your configuration file.

Supported Providers

SQL Server

Product Provider Key
Microsoft SQL Server, provider V2.0.0.0 in framework .NET V2.0 SqlServer-20

SQL Server CE

Product Provider Key
Microsoft SQL Server Compact Edition, provider V3.5.1.0 in framework .NET V2.0 SqlServerCe-351
Microsoft SQL Server Compact Edition, provider V3.5.1.50 in framework .NET V2.0 SqlServerCe-352
Microsoft SQL Server Compact Edition, provider V4.0.0.0 in framework .NET V4.0 SqlServerCe-400

Oracle

Product Provider Key
Oracle, Oracle provider V2.102.2.20 OracleODP-20

MySQL

Product Provider Key
MySQL, MySQL provider 1.0.10.1 MySql-10
MySQL, MySQL provider 1.0.9.0 MySql-109
MySQL, MySQL provider 5.0.9.0 MySql-50
MySQL, MySQL provider 5.1.6.0 MySql-51

PostgreSQL

Product Provider Key
Npgsql 2.0 Npgsql-20

SQLite

Product Provider Key
SQLite-dotnet2 SQLite-10

FireBird

Product Provider Key
FireBird 2.0.1 Firebird-201
FireBird 2.1.0 Firebird-210

OleDB

Product Provider Key
OleDb, provider V2.0.0.0 in framework .NET V2 OleDb-20

Unsupported Providers

If you would like to use a database provider that is not included in the Quartz.Net distribution, you have a couple of options:

  1. Add your provider to the dbprovider.properties file and recompile the binaries. If you decide to go down this route, please contribute your changes back to the project!
  2. If you just want to use a different (newer or older) version of a provider that is already included in the distribution, and the providers are compatible, you can use assembly redirection to point Quartz.Net to a specific version of the dll for your provider.
  3. You can programmatically add the provider. This option however is not available unless you are running the scheduler embedded in your application or have your own windows service for running Quartz.Net.