After i attempt to deploy planned table into database with GenerateSchema..i recieve the exception:

NHibernate.HibernateException: Couldn't produce the driver from NHibernate.Driver.SQLiteDriver. ---> System.Reflection.TargetInvocationException: Exception continues to be tossed through the target of the invocation. ---> NHibernate.HibernateException: The IDbCommand and IDbConnection implementation within the set up SQLite.Internet couldn't be located. Be sure that the set up SQLite.Internet is situated within the application directory or perhaps in the worldwide Set up Cache. When the set up is incorporated in the GAC, use aspect in the applying configuration file to specify the entire title from the set up..

I attempted to resolve this with NHibernate.Driver.SQLiteDriver -> NHibernate.Driver.SQLite20Driver..but didn't labored..I added all references for NHibernate, Sqlite..Linfu...

Has anybody idea for solution??

A stab at nighttime:

The main one factor have a tendency to catches me by helping cover their SQLite is it's a mixed set up it consists of both handled and native code and targets one configuration (typically x86). If you are focusing on a 64 bit operating-system and taking advantage of the x86 version, then you definitely might be getting issues with bitness. Regrettably, this does not create a helpful error message.

Try setting any project to construct using x86 and find out in the event that helps. Also, make certain you have the right version of SQLite. Some versions ('managed only') aren't effective as they are. I personally use this version (unzip after which make use of the "System.Data.SQLite.DLL" file in the root directory).

I've run into these problems in the past and it took a bit of trial and error to get it working.