code snippets for "Avoiding Leaking Connections With NHibernate And TransactionScope" post

s1.cs

    [TestFixture]
    public class ConnectionLeakTest
    {
        private static ISessionFactory sessionFactory;
 
        static ConnectionLeakTest()
        {
            sessionFactory = new Configuration()
                .Configure()
                .AddAssembly("MyAssembly")
                .BuildSessionFactory();
        }
 
        [Test]
        public void LeaksConnection()
        {
            var counter = 11;
            for (int i = 0; i < counter; i++)
            {
                using (var scope = new TransactionScope(TransactionScopeOption.Required))
                {
                    using (var session = sessionFactory.OpenSession())
                    {
                        var blah = session.CreateCriteria<User>().List<User>();
                    }
                }
            }
        }
    }

s2.cs

        [Test]
        public void LeaksConnection()
        {
            var counter = 11;
            for (int i = 0; i < counter; i++)
            {
                using (var scope = new TransactionScope(TransactionScopeOption.Required))
                {
                    using (var session = sessionFactory.OpenSession())
                    using (var transaction = session.BeginTransaction())
                    {
                        var blah = session.CreateCriteria<User>().List<User>();
                        transaction.Rollback();
                    }
                }
            }
        }

s3.cs

            using (var scope = new TransactionScope(TransactionScopeOption.Required))
            {
                using (var session = sessionFactory.OpenSession())
                using (var transaction = session.BeginTransaction())
                {
                    // do what you need to do with the session
                    transaction.Commit();
                }
                scope.Complete();
            }