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:
- 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!
- 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.
- 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.