using (ISession session= _SessionFactory.OpenSession())
{
   //here are some checks, some other code and some stuff as well...
   //loading persistent classes
   using (ITransaction transaction = session.BeginTransaction())
   {
      try
      {
         //Create some new objects/change properties of the objects
         session.Update(myobject);
         transaction.Commit();
      }
      catch
      {
         transaction.Rollback();
      }
   }
}

AspNetApplication app = null;
try
{
   //Because I can't directely check for tables with NHibernate - this will throw an error if the table doesn't exist.
   app = GetApplication(_SessionFactory.OpenSession(), this.ApplicationName, false);
}
catch
{
   try
   {
      DatabaseUtility du = new DatabaseUtility();
      du.GenerateSchema(cfg);
   }
   catch (Exception e) //what type of exception is it really??
   {
      throw new ProviderException("Unable to generate database.", e);
   }
}
finally
{
   if (app != null)
      app = null;
}