finisar.sqlite.sqliteconnection
情况:我想存储少量的数据,在数据库,
2,并且使用nhibernate
nhibernate对access的支持算不上好,所以我就选择使用了sqlite,但是同样的代码在ms sql server上能通过但就是就对sqlite通过不过,通过一步,步地跟踪发现sqlite的构造函数是如下的情况
public sqlitedriver() : base(
"sqlite.net",
"finisar.sqlite.sqliteconnection",
"finisar.sqlite.sqlitecommand")
{
}
而nhibernate中sqlite中使用的sqlite的dll却是使用的
因为dll不对,所以经常出现不能 could not create driver from ***这个错误,在使用这个版本的时候,我们应将sqlite3.dll这个dll拷贝到执行目录下,不然的话,会出错
这是使用sqlite时用到的配置文件,(注,只适用于nhibernate 1.2版本,其它版本请不要参考)
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configsections>
<section name="nhibernate" type="system.configuration.namevaluesectionhandler, system, version=1.0.5000.0,culture=neutral, publickeytoken=b77a5c561934e089" />
<section name="log4net" type="log4net.config.log4netconfigurationsectionhandler,log4net" />
</configsections>
<nhibernate>
<!--
<add key="hibernate.show_sql"
value="true" />
<add key="hibernate.connection.provider"
value="nhibernate.connection.driverconnectionprovider" />
<add key="hibernate.dialect"
value="nhibernate.dialect.mssql2000dialect" />
<add key="hibernate.connection.driver_class"
value="nhibernate.driver.sqlclientdriver" />
<add key="hibernate.connection.connection_string"
value="server=.cxy;database=mytest;uid=sa;pwd=cxy" />
-->
<add key="hibernate.show_sql"
value="nhibernate.dialect.sqlitedialect" />
value="nhibernate.driver.sqlitedriver" />
value="data source=cxy.db;version=3" />
<add key="hibernate.query.substitutions"
value="true=1;false=0" />
</nhibernate>
<!-- this section contains the log4net configuration settings -->
<log4net>
<!-- define some output appenders -->
<appender name="rollingfile" type="log4net.appender.rollingfileappender,log4net" >
<param name="file" value="log.txt" />
<param name="appendtofile" value="true" />
<param name="rollingstyle" value="date" />
<param name="datepattern" value="yyyy.mm.dd" />
<param name="staticlogfilename" value="true" />
<layout type="log4net.layout.patternlayout,log4net">
<param name="conversionpattern" value="%d [%t] %-5p %c [%x] &lt;%x{auth}&gt; - %m%n" />
</layout>
</appender>
<!-- setup the root category, add the appenders and set the default priority -->
<root>
<priority value="all" />
<appender-ref ref="rollingfile" />
</root>
</log4net>
</configuration>