OracleConnection con=new OracleConnection(ConnectionString);
if(con.State==ConnectionState.Closed)
{
con.Open();
}
OracleTransaction trans =con.BeginTransaction();
OracleCommand cmd=con.CreateCommand(); cmd.CommandText=...; //一个sql
cmd.ExecuteNonQuery();执行 cmd.ExecuteNonQuery();时出错如下:System.InvalidOperationException: Execute requires the Command object to have a Transaction object when the Connection object assigned to the Command is in a pending local transaction. The Transaction property of the Command has not been initialized.
if(con.State==ConnectionState.Closed)
{
con.Open();
}
OracleTransaction trans =con.BeginTransaction();
OracleCommand cmd=con.CreateCommand(); cmd.CommandText=...; //一个sql
cmd.ExecuteNonQuery();执行 cmd.ExecuteNonQuery();时出错如下:System.InvalidOperationException: Execute requires the Command object to have a Transaction object when the Connection object assigned to the Command is in a pending local transaction. The Transaction property of the Command has not been initialized.
OracleTransaction trans =con.BeginTransaction();
OracleCommand cmd=con.CreateCommand();
cmd.Transaction = trans;//Set transaction to commandcmd.CommandText=...; //一个sql
cmd.ExecuteNonQuery();
trans.Commit(); //Commit transaction