How to implement session-per-request pattern in asp.net mvc with Nhibernate

Question

I created the nhibernate session in Application_start event of global.asax file,the session is being passed to constructors of service methods.

In the service method I am using the session to do CRUD operations, this works fine.However, When multiple requests or parallel transactions occuring nhibernate is throwing some exceptions.After reading forums i came to know that Nhibernate session is not thread safe.How to make it thread safe and let my application (ASP.NET mvc) work with parallel trandsactions?

Community · Accepted Answer · 2017-05-23 12:22:31Z

1

Only way to make it thread safe is to create a new session per each request, you could use current_session_context_class property to managed_web in NHibernate config.

In global.asax

    protected void Application_BeginRequest(object sender, EventArgs e)
    {
        var session = SessionFactory.OpenSession();
        CurrentSessionContext.Bind(session);
    }

    protected void Application_EndRequest(object sender, EventArgs e)
    {
        var session = CurrentSessionContext.Unbind(SessionFactory);
        //commit transaction and close the session
    }

now when you want to access the session, you could use,

Global.SessionFactory.GetCurrentSession()

If you are using a DI container, it's usually built into the container,

For example for Autofac (see this question for more information),

containerBuilder.Register(x => {
    return x.Resolve<ISessionFactory>().OpenSession(); 
}).As<ISession>().InstancePerHttpRequest();

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Jun 21, 2016 at 0:06

Low Flying Pelican

6,0621 gold badge36 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Raghu Over a year ago

without using dependency injection how can we get session from global.asax to data access layer?

Low Flying Pelican Over a year ago

Global.SessionFactory.GetCurrentSession()

Raghu Over a year ago

if data access layer is in different project? how to access it.

Low Flying Pelican Over a year ago

You could reference the project, or you might want to consider using DI

Fran · Accepted Answer · 2016-06-17 17:50:47Z

0

Store it in the HttpContext.

Add this to your global.asax

    public static String sessionkey = "current.session";

    public static ISession CurrentSession
    {
        get { return (ISession)HttpContext.Current.Items[sessionkey]; }
        set { HttpContext.Current.Items[sessionkey] = value; }
    }

    protected void Application_BeginRequest()
    {
        CurrentSession = SessionFactory.OpenSession();
    }

    protected void Application_EndRequest()
    {
        if (CurrentSession != null)
            CurrentSession.Dispose();
    }

And here is the component registration

public class SessionInstaller : IWindsorInstaller
{
    public void Install(IWindsorContainer container, IConfigurationStore store)
    {
        container
            .Register(Component.For<ISession>().UsingFactoryMethod(() => MvcApplication.CurrentSession)
            .LifeStyle
            .PerWebRequest);
    }
}

edited Jun 17, 2016 at 17:50

answered Jun 17, 2016 at 17:30

Fran

6,5801 gold badge26 silver badges37 bronze badges

3 Comments

Raghu Over a year ago

If we store the session in httpcontext, how can we access it from Data access layer project. I am not using Dependency Injection.please advice

Fran Over a year ago

you are confusing a couple of things. 1. You can't start the session in Application_Start and use it for every user that comes in. This is why you start the session in Application_BeginRequest. you want to scope the session to the http request. 2. The session doesn't have to be thread safe if you aren't going to update it from multiple threads. In Application_Start, you want to build your SessionFactory.

Fran Over a year ago

if you aren't using DI, just pass the MvcApplication.CurrentSession to your controller constructor

Collectives™ on Stack Overflow

How to implement session-per-request pattern in asp.net mvc with Nhibernate

2 Answers 2

4 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related