gistfile1.txt

public class InMemoryDatabaseTest : IDisposable
    {
        private static Configuration _cfg;
        private static ISessionFactory _sessionFactory;
        protected ISession _session;

        public InMemoryDatabaseTest(Assembly assemblyContainingMapping)
        {
            if (_sessionFactory == null)
            {
                _sessionFactory =
                    Fluently.Configure()
                        .Database(SQLiteConfiguration.Standard.InMemory())
                        .Mappings(m => m.FluentMappings.AddFromAssembly(assemblyContainingMapping))
                        .ExposeConfiguration(cfg => _cfg = cfg)
                    .BuildSessionFactory();
            }

            _session = _sessionFactory.OpenSession();

            new SchemaExport(_cfg).Execute(true, true, false, _session.Connection, Console.Out);
        }

        public void Dispose()
        {
            _session.Dispose();
        }
    }