Mistery solved: If you get the configuration template from the NHibernate's lib \NHibernate\Configuration_Templates folder, they you have to get the dll for sqllite from this url http://sourceforge.net/projects/adodotnetsqlite/ which is SQLite and driver is NHibernate.Driver.SQLiteDriver. But as the web site says this project is deceased.
So you go and download new System.Data.SQLite.DLL from this url or from FluentNhibernate lib folder http://sourceforge.net/projects/sqlite-dotnet2/ and driver is NHibernate.Driver.SQLite20Driver See that 20 in the driver name? Anyway just though I might clarify the mystery. On Sep 23, 8:32 am, Maik <[email protected]> wrote: > also check to deliver a local copy of the sqlite-dll to the > application. > seems to me that this would help. > > On 23 Sep., 14:39, epitka <[email protected]> wrote: > > > > > So, I am trying to use Sqlite with NH and I am getting an error. > > > The IDbCommand and IDbConnection implementation in the assembly > > SQLite.NET could not be found. Ensure that the assembly SQLite.NET is > > located in the application directory or in the Global Assembly Cache. > > If the assembly is in the GAC, use element in the application > > configuration file to specify the full name of the assembly. > > > Did any of you guys out there experience something similar? > > > Let me say that dll is in the bin directory, I made sure. I am using > > System.Data.SQLite.DLL version 1.0.60.0. I am running this on Window > > XP box. I am using FluentNH to configure SessionFactory: > > > _sessionFactory = Fluently.Configure(cfg) > > .Mappings(m=> m.FluentMappings.AddFromAssembly > > (Assembly.Load("dnnSphere.Meta"))) > > .BuildSessionFactory(); > > > Here is the hibernate.cfg.xml: > > > <property name="connection.driver_class"> > > NHibernate.Driver.SQLiteDriver > > </property> > > <property name="connection.connection_string"> > > Data Source=nhibernate.db;Version=3 > > </property> > > <property name="dialect">NHibernate.Dialect.SQLiteDialect</property> > > > <property name="query.substitutions">true=1;false=0</property> > > > <property name="show_sql">true</property> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
