ASP.NET MVC, NHibernate sessions, and NHibernate events

Question

I'm using (Fluent) NHibernate in an ASP.NET MVC3 project. I'm using the standard approach of opening one NHibernate session per request by implementing a custom HttpModule. The session gets opened in BeginRequest and closed in EndRequest.

I'm hooking into the Pre/Post Insert/Update events to write a history log for my entities. The problem arises when I try to save the entity in these event handlers. It seems as though EndRequest has already been called before these event handlers, and hence the NHibernate session is already closed.

How can I delay the closing of the session so I can save the history entities? I've looked at some of the HttpModules at rhino commons, but it seems overkill for my situation.

Use a dedicated Session to perform these tasks, maybe? We use these events for auditing purposes also, and we perform these operations in a separate Session. — Pedro
– Pedro, Commented Jul 30, 2012 at 20:51
Those events occur within the transaction. You are using transactions, right? — Diego Mijelshon
– Diego Mijelshon, Commented Jul 31, 2012 at 1:28
@DiegoMijelshon Yes, everything within the request is handled in a transaction. The problem is that the request is ending before the event handlers are called. — arknotts
– arknotts, Commented Aug 3, 2012 at 13:28

Kris McGinnes · Accepted Answer · 2012-07-31 04:33:13Z

1

You might want to check out this post by Ayende. I believe you'll find your answer in the comments made by Revin Hart. Ayende and Revin talk about getting a child session to handle saving the change log entity.

ISession newSession = ev.Source.PersistenceContext.Session.GetSession();

foreach (ScheduleChangeLog changeLog in logs)
{
    changeLog.UpdatedBy = Username;
    newSession.Save(changeLog);
}

answered Jul 31, 2012 at 4:33

Kris McGinnes

3922 silver badges8 bronze badges

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

1 Comment

arknotts Over a year ago

Perfect! Long story short I did have to create a new session.

Collectives™ on Stack Overflow

ASP.NET MVC, NHibernate sessions, and NHibernate events

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related