Yes, I already have database lock.
On Sep 23, 9:31 am, Maik <[email protected]> wrote:
> 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...
>
> 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
-~----------~----~----~----~------~----~------~--~---
