Use SQLite as the job store of quartz. net

We plan to use the latest SQLite version as the job store of quartz. net.

Add the following content to dbproviders. properties under quartz. impl. adojobstore. Common:

# SQLite 1.0.61.0 + ado net provider for SQLite
# Driver can be found at: http://sqlite.phxsoftware.com
Quartz. dbprovider. SQLite-106.assemblyName = system. Data. SQLite, version = 1.0.61.0, culture = neutral, publickeytoken = db937bc2d44ff139
Quartz. dbprovider. SQLite-106.connectionType = system. Data. SQLite. sqliteconnection, system. Data. SQLite, version = 1.0.61.0, culture = neutral, publickeytoken = db937bc2d44ff139
Quartz. dbprovider. SQLite-106.commandType = system. Data. SQLite. sqlitecommand, system. Data. SQLite, version = 1.0.61.0, culture = neutral, publickeytoken = db937bc2d44ff139
Quartz. dbprovider. SQLite-106.parameterType = system. Data. SQLite. sqliteparameter, system. Data. SQLite, version = 1.0.61.0, culture = neutral, publickeytoken = db937bc2d44ff139
# Quartz. dbprovider. SQLite-106.dataAdapterType = system. Data. SQLite. sqlitedataadapter, system. Data. SQLite, version = 1.0.61.0, culture = neutral, publickeytoken = db937bc2d44ff139
Quartz. dbprovider. SQLite-106.commandBuilderType = system. Data. SQLite. sqlitecommandbuilder, system. Data. SQLite, version = 1.0.61.0, culture = neutral, publickeytoken = db937bc2d44ff139
# Quartz. dbprovider. SQLite-106.commandBuilderDeriveParametersMethod = deriveparameters
Quartz. dbprovider. SQLite-106.parameterDbType = system. Data. SQLite. typeaffinity, system. Data. SQLite, version = 1.0.61.0, culture = neutral, publickeytoken = db937bc2d44ff139
Quartz. dbprovider. SQLite-106.parameterDbTypePropertyName = dbtype
# Quartz. dbprovider. SQLite-106.parameterIsNullableProperty = isnullable
Quartz. dbprovider. SQLite-106.parameterNamePrefix = @
Quartz. dbprovider. SQLite-106.exceptionType = system. Data. SQLite. sqliteexception, system. Data. SQLite, version = 1.0.61.0, culture = neutral, publickeytoken = db937bc2d44ff139
Quartz. dbprovider. The SQLite-106.useParameterNamePrefixInParameterCollection = true
Quartz. dbprovider. The SQLite-106.bindByName = true

Add the following content to the quartz configuration file:

<Add key = "quartz. datasource. Default. connectionstring" value = "Data Source = D: \ quartz. db3; version = 3;"/>
<Add key = "quartz. datasource. Default. provider" value = "SQLite-106"/>