使用SQLite作为Quartz.Net的Job Store

前端之家收集整理的这篇文章主要介绍了使用SQLite作为Quartz.Net的Job Store前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
文章导读】打算使用最新版本sqlite作为Quartz.Net的Job Store。在Quartz.Impl.AdoJobStore.Common下的dbproviders.properties添加以下内容: # sqlite 1.0.61.0 + ADO Net provider for sqlite # Driver can be found at : http://sqlite.phxsoftware.com quartz.dbprovider.sqlite-106.assemblyName

打算使用最新版本sqlite作为Quartz.Net的Job Store。

在Quartz.Impl.AdoJobStore.Common下的dbproviders.properties添加以下内容

# 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,PublicKeyToken=db937bc2d44ff139
quartz.dbprovider.sqlite-106.commandType=System.Data.sqlite.sqliteCommand,PublicKeyToken=db937bc2d44ff139
quartz.dbprovider.sqlite-106.parameterType=System.Data.sqlite.sqliteParameter,PublicKeyToken=db937bc2d44ff139
#quartz.dbprovider.sqlite-106.dataAdapterType=System.Data.sqlite.sqliteDataAdapter,PublicKeyToken=db937bc2d44ff139
quartz.dbprovider.sqlite-106.commandBuilderType=System.Data.sqlite.sqliteCommandBuilder,PublicKeyToken=db937bc2d44ff139
#quartz.dbprovider.sqlite-106.commandBuilderDeriveParametersMethod=DeriveParameters
quartz.dbprovider.sqlite-106.parameterDbType=System.Data.sqlite.TypeAffinity,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,PublicKeyToken=db937bc2d44ff139
quartz.dbprovider.sqlite-106.useParameterNamePrefixInParameterCollection=true
quartz.dbprovider.sqlite-106.bindByName=true

在Quartz的配置文件中,添加以下内容

<add key="quartz.dataSource.default.connectionString" value="Data Source=d:\quartz.db3;Version=3;" /> <add key="quartz.dataSource.default.provider" value="sqlite-106" />

原文链接:https://www.f2er.com/sqlite/202209.html

猜你在找的Sqlite相关文章