事务处理

public void UseTransaction()
        ...{
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbcomm1 = db.GetSqlStringCommand("update person set name='pw'");
            DbCommand dbcomm2 = db.GetSqlStringCommand("delete from person where id=1");

            using (DbConnection conn = db.CreateConnection())
            ...{
                //打开连接
                conn.Open();
                //创建事务
                DbTransaction trans = conn.BeginTransaction();

                try
                ...{
                    db.ExecuteNonQuery(dbcomm1);

                    db.ExecuteNonQuery(dbcomm2);

                    //都执行成功则提交事务
                    trans.Commit();
                }
                catch(Exception)
                ...{
                    //发生异常，事务回滚
                    trans.Rollback();
                }
                //关闭连接
                conn.Close();
            }
        }