Hi
I am trying to use an SQLite database in my solution and am having some trouble getting it working. I have the same mapping files working with SQL Server 2005 but when I try to use an SQLite database I get the following error
NHibernate.HibernateException: Unable to load DLL 'coredll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
at NHibernate.Tool.hbm2ddl.SchemaExport.Execute(Boolean script, Boolean export, Boolean justDrop, Boolean format) in c:\net\nhibernate\nhibernate\src\NHibernate\Tool\hbm2ddl\SchemaExport.cs:line 275
at NHibernate.Tool.hbm2ddl.SchemaExport.Create(Boolean script, Boolean export) in c:\net\nhibernate\nhibernate\src\NHibernate\Tool\hbm2ddl\SchemaExport.cs:line 87
at NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings) in c:\net\nhibernate\nhibernate\src\NHibernate\Impl\SessionFactoryImpl.cs:line 262
at NHibernate.Cfg.Configuration.BuildSessionFactory() in c:\net\nhibernate\nhibernate\src\NHibernate\Cfg\Configuration.cs:line 1063
at CCM.ProcessDesigner.Data.NHibernateHelper.SetUpSpecificData(XmlTextReader reader) in NHibernateHelper.cs:line 31
at CCM.ProcessDesigner.Data.Session..ctor(XmlTextReader reader) in Session.cs:line 26
at CCM.ProcessDesigner.Data.Tests.NHibernateTests.TestConnectToSeperateDataSourceSQLite() in NHibernateTests.cs:line 541
System.DllNotFoundException: Unable to load DLL 'coredll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
at Finisar.SQLite.Util.GetProcessHeap()
at Finisar.SQLite.Util.AllocateUnmanagedMemory(Int32 size)
at Finisar.SQLite.MarshalStr.GetSQLiteStr()
at Finisar.SQLite.sqlite3.open(String filename)
at Finisar.SQLite.SQLiteConnection.Open()
at NHibernate.Connection.DriverConnectionProvider.GetConnection() in c:\net\nhibernate\nhibernate\src\NHibernate\Connection\DriverConnectionProvider.cs:line 46
at NHibernate.Tool.hbm2ddl.SchemaExport.Execute(Boolean script, Boolean export, Boolean justDrop, Boolean format) in c:\net\nhibernate\nhibernate\src\NHibernate\Tool\hbm2ddl\SchemaExport.cs:line 262
I am using the DLL I found at this site:
http://sourceforge.net/projects/adodotnetsqlite
Is this the correct way to use SQLite with nhibernate?