数据库事务:数据库中开始一个事务来源: 发布时间:星期三, 2008年9月10日 浏览:110次 评论:0
下面的示例创建一个 OracleConnection 和一个 OracleTransaction。它还演示了如何使用 BeginTransaction、Commit 和 Rollback 方法。
public void RunOracleTransaction(string myConnString) { OracleConnection myConnection = new OracleConnection(myConnString); myConnection.Open(); OracleCommand myCommand = myConnection.CreateCommand(); OracleTransaction myTrans; // Start a local transaction myTrans = myConnection.BeginTransaction(IsolationLevel.ReadCommitted); // Assign transaction object for a pending local transaction myCommand.Transaction = myTrans; try { myCommand.CommandText = \"INSERT INTO Dept (DeptNo, Dname, Loc) values (50, \'TECHNOLOGY\', \'DENVER\')\"; myCommand.ExecuteNonQuery(); myCommand.CommandType= CommandType.StoredProcedure; myCommand.CommandText=\"prc_test\"; myCommand.ExecuteNonQuery(); myTrans.Commit(); Console.WriteLine(\"Both records are written to database.\"); } catch(Exception e) { myTrans.Rollback(); Console.WriteLine(e.ToString()); Console.WriteLine(\"Neither record was written to database.\"); } finally { myConnection.Close(); } } 0
相关文章
读者评论
发表评论 |