(OracleConnection connection1 = new OracleConnection(connectionstring1) )// databsse1 {OracleConnection connection2=new OracleConnection (connectionstring2);//database2 connection.Open(); OracleCommand command = connection.CreateCommand(); OracleTransaction trans; trans = connection.BeginTransaction(IsolationLevel.ReadCommitted); command.Transaction = trans; try { command.Text =sql1//insert into table1 in database1 command.ExecuteNonQuery(); command.Text =sql2//insert into table2 in database2 //Here the problem by looking for a solution How can I do that trans.Commit(); } catch (Exception ex) { trans.Rollback(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)