Using SQLite with NHibernate on 64 bit Windows17 Mar 2010
If you encounter an exception like this when initializing the ISessionFactory under FluentNHibernate with a 64 bit version of Windows
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 <qualifyAssembly/> element in the application configuration file to specify the full name of the assembly.
Then you should probably ensure that the project is compiled for “x86” instead of “Any” in the project properties dialog.