对于websharp事务处理的使用心得

       这里用了10200000000000000是为了使程序产生异常,而观察Product p1是否会被添加到数据库中,如果使用了事务处理,则p1不被添加到数据库;如果未使用事务处理,则p1仍然被添加到数据库,见以下代码:

加事务处理的部分源代码

 private void NormalInsert()
    {
        DatabaseProperty dbp = new DatabaseProperty();
        dbp.DatabaseType = DatabaseType.MSSQLServer;
        dbp.ConnectionString = "server=(local);uid=sa;pwd=sa;database=WebsharpTest";

        PersistenceManager pm = PersistenceManagerFactory.Instance().Create(dbp);

        Transaction t = pm.CurrentTransaction;     //获取当前事务对象
        t.Begin();                                   //开始事务
        try
        {
            Product p1 = new Product("liping", 10000);
            pm.PersistNew(p1);
            Product p0 = new Product(this.producttxt.Text, 1020000000000000000);
            pm.PersistNew(p0);
            pm.Flush();
            t.Commit();                                  //提交事务
        }
        catch
        {
            t.Rollback();
        }
        finally
        {
            pm.Close();
        }
}

 得到的结果为:

不加事务处理的源代码

 private void NormalInsert()
    {
        DatabaseProperty dbp = new DatabaseProperty();
        dbp.DatabaseType = DatabaseType.MSSQLServer;
        dbp.ConnectionString = "server=(local);uid=sa;pwd=sa;database=WebsharpTest";

        PersistenceManager pm = PersistenceManagerFactory.Instance().Create(dbp);

        //Transaction t = pm.CurrentTransaction;     //获取当前事务对象
        //t.Begin();                                   //开始事务
        try
        {
            Product p1 = new Product("liping", 10000);
            pm.PersistNew(p1);
            Product p0 = new Product(this.producttxt.Text, 1020000000000000000);
            pm.PersistNew(p0);
            pm.Flush();
        //    t.Commit();                                  //提交事务
        }
        catch
        {
         //   t.Rollback();
        }
        finally
        {
            pm.Close();
        }
}

运行结果:

 说明加事务处理的产生了事务回滚,p1没有插入数据库中,不加事务处理的p1插入到数据库中