An example of using the Configuration class with an In-Memory SQLite DB

gistfile1.cs

[TestFixtureSetUp]
public void FixtureSetUp()
{   
    Configuration cfg;
    Models.Data.Util.Configuration.ConfigureDataAccess(SQLiteConfiguration.Standard.InMemory(), 
																	InstanceScope.Singleton, out cfg);

    session = ObjectFactory.GetInstance<ISession>();
    
    IDbConnection connection = session.Connection;

    Dialect _dialect = Dialect.GetDialect(cfg.Properties);
    string[] drops = cfg.GenerateDropSchemaScript(_dialect);
    ExecuteScripts(drops, connection);

    string[] scripts = cfg.GenerateSchemaCreationScript(_dialect);
    ExecuteScripts(scripts, connection);
}

private static void ExecuteScripts(IEnumerable<string> scripts, IDbConnection connection)
{
    foreach (string script in scripts)
    {
        IDbCommand command = connection.CreateCommand();
        command.CommandText = script;
        command.ExecuteNonQuery();
    }
}