SQLite NHibernate configuration with .Net 4.0 and vs 2010

Question

UPDATE

In the last update I could use SQLite for unit testing but not in an application run. That problem has now been resolved by modifying config to allow [loading from a remote assembly](http://msdn.microsoft.com/en-us/library/dd409252(VS.100.aspx)

<runtime>
    <loadFromRemoteSources enabled="true"/>
</runtime>

in addition to enabling mixed mode loading (see Mauricio's answer below), using the latest SQLite dll here at Source Forge, and cleaning out the GAC from a previous install of SQLite

Cheers,
Berryl

Answer 1

1. Sure. You can also use previous versions if you configure mixed mode loading.
2. No need to be in the GAC. You can use gacutil to remove the assemblies from the GAC.
3. Use the x64 DLL to target Windows x64 and x86 for Windows x86
4. Please post the full exception stack trace. Also if you're using a 3.5 assembly use mixed mode loading.
5. FNH has no reference to SQLite.

Answer 2

I installed from http://sqlite.phxsoftware.com/ -> SourceForge...

Basically, I am having the same issue.

I am getting this: Tests.Northwind.Data.StaffMemberRepositoryTests.CanLoadStaffMembersMatchingFilter: FluentNHibernate.Cfg.FluentConfigurationException : An invalid or incomplete configuration was used while creating a SessionFactory. Check PotentialReasons collection, and InnerException for more detail.

• Database was not configured through Database method.

  ----> NHibernate.HibernateException : Could not create the driver from NHibernate.Driver.SQLite20Driver. ----> System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation. ----> NHibernate.HibernateException : The IDbCommand and IDbConnection implementation in the assembly System.Data.SQLite could not be found. Ensure that the assembly System.Data.SQLite 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.

Answer 3

I want this to stand out so it will help someone else; the full reason this happens is explained here; so adjust your congig to use BOTH the redirect there in combo with the mixed loading mode referenced here by Mauricio.