Alo We have alot of SP and now we want to only using NHibernate/ Activerecord. The SessionScope which create a implicit NHibernate Transaction typically looks like this:
NHibernate call1 -> NHibernate call2 -> SP call1 The database isolation level is set to Read Committed. And SP is executed with its own connection (total separated from NHibernate) If NHibernate call1 use table A and SP call1 also use table A we will have a problem because table A is locked by NHibernate transaction. I think one way to solve this is to commit the transaction before SP call1 by using TransactionScope. This change have to done all places with this combination I am looking for at more generic solution. How about using the IDBConnection from NHibernate session to execute the SP call1. Will this solve the problem? Thx in advance -- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en.
