By the way I am using Session-Per-Web-Request as this appears to be the recommend way to use NHibernate with Asp .NET.
This means that I definitely don't want to be wrapping the entire session in a transaction (the method that Ayende uses on his blog). I want to be using TransactionScope like you would use an NHibernate transaction - i.e. multiple transaction per session. Clearly NHibernate breaks when using nested transactions though, so I'm kind of stuck. On Oct 19, 12:59 pm, acl123 <[email protected]> wrote: > In this case, the second ADO command is committed to the database, > whilst the first is rolled back. What is going on? This seems very > weird to me. > > This is kind of a follow up question to my previous post > here:http://groups.google.com/group/nhusers/browse_thread/thread/241cc0430... > > [TestFixture] > public class TestFixture > { > [Test] > public void Test() > { > using(var factory = _config.BuildSessionFactory()) > { > using (var session = factory.OpenSession()) > { > CallSessionContext.Bind(session); > > using(new TransactionScope()) > { > using (session.BeginTransaction()) > { > // Do something with an NHibernate > mapped entity > } > > using(var connection = new SqlConnection > (_connectionString)) > { > // Execute an insert statement > } > } > > CallSessionContext.Unbind(factory); > } > } > } > } --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
