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(); } }