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