Working with SQLite will bring up some problems concerning Schema- Support.
Have a look at this, if you like to: http://blog.theagileworkshop.com/2009/06/09/using-schemas-with-sqlite-for-in-memory-nhibernate-tests/ On 23 Sep., 16:21, epitka <[email protected]> wrote: > 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 urlhttp://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 > folderhttp://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 -~----------~----~----~----~------~----~------~--~---
