I recently posted about using SQLite to speed up integration tests when using NHibernate and one of the issues I was having was the inmemory database being dropped.  I had been meaning to spend some time working out what the problem was but Justin Etheredge has done the hard work and figured out the solution!

Check it out here: http://www.codethinked.com/post/2008/10/19/NHibernate-20-SQLite-and-In-Memory-Databases.aspx  Good job Justin, I owe you a pint!

So, for those of you that use Binsor, the updated script now looks like this:

settings(keymap, item: 'item'):
   provider = 'NHibernate.Connection.DriverConnectionProvider'
   connection.driver_class = 'NHibernate.Driver.SQLite20Driver'
   dialect = 'NHibernate.Dialect.SQLiteDialect'
   connection.connection_string = 'Data Source=:memory:'
   connection.release_mode = 'on_close'
   cache.use_second_level_cache= 'false'

The "connection.connection_string" and "connection.release_mode" are the options that have changed.