While using the System.Data.SQLite ADO.NET Provider for NHibernate I kept getting an SQLiteException : 'no such table : [EntityName]' . This isn't an NHibernate bug. SQLite couldn't find the database. I found info here and here where the keyword |DataDirectory| (using the pipes) should be prepended to the database name. So my new connection string is "DataSource=|DataDirectory|inmemory.db;Version=3;New=True;" SQLite will try to find the db and if it can't will use the directory where it is running, as it should. Be careful not to have funny characters like colons in the database name or else it still bombs.
After this fix I don't get this error anymore.