Start a transaction in the database

Data | Database The following example creates a OracleConnection and a oracletransaction. It also demonstrates how to use the BeginTransaction, Commit, and Rollback methods.

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 (, ' 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 is written to database.");
}
Finally
{
Myconnection.close ();
}
}