01-06-01【Nhibernate (版本3.3.1.4000) 出入江湖】事务

 

Nhibernate事务的使用：

        public void Add(Customer customer)
        {
            ISession session = _sessionManager.GetSession();
            ITransaction transaction = session.BeginTransaction();

            try
            {
                session.Save(customer);
                session.Flush();//清除一级缓存
                
                transaction.Commit();
            }
            catch (Exception)
            {
                transaction.Rollback();
            }
            finally
            {
                session.Close();
            }
        }

 

测试：

       [TestMethod]
       [ExpectedException(typeof(NHibernate.Exceptions.GenericADOException))]
       public void TestAddTransation()
       {
           CustomerService customerService = new CustomerService();
           OrderService orderService = new OrderService();

           Customer customer1 = new Customer()
           { 
               FirstName = "Test",
               LastName = "TestAddTransation1",
               Age = 10
           };
           Order order1 = new Order()
           {
               OrderDate = DateTime.Now.AddMinutes(1),
               Customer = customer1
           };
           Order order2 = new Order()
           {
               OrderDate = DateTime.Now.AddMinutes(2),
               Customer = customer1
           };

           Customer customer2= new Customer()
           {
               FirstName = null,  //数据库要求不能为null，现在故意引发添加异常
               LastName = "TestAddTransation",
               Age = 10
           };
           Order order3 = new Order()
           {
               OrderDate = DateTime.Now.AddMinutes(3),
               Customer = customer2
           };
           Order order4 = new Order()
           {
               OrderDate = DateTime.Now.AddMinutes(4),
               Customer = customer2
           };

           customer1.Orders.Add(order1);
           customer1.Orders.Add(order2);
           customer2.Orders.Add(order3);
           customer2.Orders.Add(order4);

           customerService.Add(customer1); //customer1及其Order1与Order2能成功插入，因为他们与Customer2不在同一个事务
           customerService.Add(customer2); //Customer2插入失败，Order3和Order4也不能成功插入。

           Assert.IsNull(customerService.Get(customer1.CustomerId));
           Assert.IsNull(orderService.Find(order1.OrderId));
           Assert.IsNull(orderService.Find(order2.OrderId));
       }

 

 

-----------------------------------------------

关于事务操作的添加：

  session.Flush();//清除一级缓存

是否会立即保存到数据库

结论是:不会立即保存的数据库，而是等到调用transaction.Commit();才真正保存到数据库：

图解：