nhibernate session

gistfile1.cs

public class Global : System.Web.HttpApplication
{
    protected void Application_Start(object sender, EventArgs e)
    {
        Application["NHSessionFactory"] = CreateSessionFactory();
    }
 
    private static ISessionFactory CreateSessionFactory()
    {
        return Fluently.Configure()
            .Database(MsSqlConfiguration.MsSql2008
                .ConnectionString(ConfigurationManager.AppSettings["ConnectionString"]))
            .Mappings(m => m.AutoMappings.Add(CreateAutomappings))
            .BuildSessionFactory();
    }
 
    private static AutoPersistenceModel CreateAutomappings()
    {
        return AutoMap
            .AssemblyOf<AutomappingConfiguration>(new AutomappingConfiguration())
            .Override<User>(u => u.Table("tUser"));
    }
 
    protected void Application_BeginRequest(object sender, EventArgs e)
    {
        ISessionFactory sessionFactory = (ISessionFactory) Application["NHSessionFactory"];
        Context.Items["NHSession"] = sessionFactory.OpenSession();
    }
 
    protected void Application_EndRequest(object sender, EventArgs e)
    {
        ISession session = (ISession) Context.Items["NHSession"];
        session.Dispose();
    }
 
    protected void Application_End(object sender, EventArgs e)
    {
        ISessionFactory sessionFactory = (ISessionFactory)Application["NHSessionFactory"];
        sessionFactory.Dispose();
    }
}


public class TransactionAttribute : ActionFilterAttribute
{
    public override void OnActionExecuting(ActionExecutingContext filterContext)
    {
        DependencyResolver.Current.GetService<ISession>().BeginTransaction(IsolationLevel.ReadCommitted);
    }
 
    public override void OnActionExecuted(ActionExecutedContext filterContext)
    {
        ITransaction currentTransaction = DependencyResolver.Current.GetService<ISession>().Transaction;
 
        if (currentTransaction.IsActive)
        {
            if (filterContext.Exception != null && filterContext.ExceptionHandled)
            {
                currentTransaction.Rollback();
            }
        }
    }
 
    public override void OnResultExecuted(ResultExecutedContext filterContext)
    {
        ITransaction currentTransaction = DependencyResolver.Current.GetService<ISession>().Transaction;
 
        base.OnResultExecuted(filterContext);
        try
        {
            if (currentTransaction.IsActive)
            {
                if (filterContext.Exception != null && !filterContext.ExceptionHandled)
                {
                    currentTransaction.Rollback();
                }
                else
                {
                    currentTransaction.Commit();
                }
            }
        }
        finally
        {
            currentTransaction.Dispose();
        }
    }
}

http://slynetblog.blogspot.co.uk/2011/04/lightweight-nhibernate-and-aspnet-mvc.html