.net - Session-in-view and TransactionScope -

.net - Session-in-view and TransactionScope -

- January 15, 2013

we have asp.net webforms app using nhibernate. here specifics:

we need distributed transactions because write database queue.
because web app, use recomended session-in-view pattern. have httpmodule opens nhibernate session on beginrequest event , closes on endrequest.
within flow of request, have several separate moments need transactional work. this, use transactionscope.

so basically, happens (pseudocode):

using(var session = sessionfactory.createsession()){   using(var tx1 = new transactionscope(){     //work work work     tx1.complete();   }    //other work    using(var tx2 = new transactionscope(){     //work work work     tx2.complete();   } }

however situation see lot of crashes related connection database. researching gave 2 suggestions:

use nhibernate transaction within transactionscope
create session within transactionscope

however, have 2 questions these suggestions:

doesn't nhibernate automatically enlist transactionscope. why need create transaction explicitly nhibernate?
if must create our session within transactionscope, how can combine session-in-view pattern?

you must use nh transactions (session.begintransaction())
nh transactions automatically enlist in transactionscope
you don't have create session inside transactionscope.

Comments