在nhibernate 1.2 中使用sqlite时应注意sqlite的ado.net的提供者

<? 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 = " true "   />
         < add key = " hibernate.connection.provider "
            value = " NHibernate.Connection.DriverConnectionProvider "   />

         < add key = " hibernate.dialect "
             value = " NHibernate.Dialect.SQLiteDialect "   />

         < add key = " hibernate.connection.driver_class "
             value = " NHibernate.Driver.SQLiteDriver "   />  

         < add key = " hibernate.connection.connection_string "
             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 >