ISession session = NHibernateHelper.GetCurrentSession();
ITransaction tx = session.BeginTransaction();

Blog blog = new Blog();
blog.Name = "My Own Blog";
blog.TablePrefix = "blog_";
...
blog.AnotherProperty = "this and that";
session.Save( blog );
   
try {
    //creates a couple of new tables based on the prefix - how do I make it create these tables?
    //Perhaps I could write the mapping xml files and somehow make them give the meta data needed to create this new blog in the database?
    tx.Commit();
}
catch {
    trans.Rollback();
}
finally {
    NHibernateHelper.CloseSession();
}

namespace Com.Benday.BugTracker.DataAccess
{
    public class SchemaUtility
    {
        public static void ExportSchema()
        {
            Configuration config = new Configuration();
            config.Configure();

            SchemaExport exporter = new SchemaExport(config);

            exporter.Drop(true, true);
            exporter.Create(true, true);
           
            // exporter.Execute(true, true, false, true);
        }
    }
}