How to use transaction?

[satu777]

How can I use Topobase.Data.Provider.Transaction?

In the Oracle the solution is the follow:
Oracle.DataAccess.Client.OracleTransaction myOracleTransaction = myOraConn.BeginTransaction();
Oracle.DataAccess.Client.OracleCommand _cmd = myOraConn.CreateCommand();
...
myOracleTransaction.Commit();

How can I do it with Topobase data provider? Please send me a short example.

[satu777]

Solution from myself... maybe if somebody needs this...

String sqlScript = "Select * from Dump";
mySqlConn = new gl2ora.SqlCon(OracleSID, OracleUsername, OraclePassword);
myOraConn = mySqlConn.Make();
Oracle.DataAccess.Client.OracleTransaction myOracleTransaction = myOraConn.BeginTransaction();
Oracle.DataAccess.Client.OracleCommand _cmd = myOraConn.CreateCommand();
_cmd.CommandText = sqlScript;
try
{
_cmd.ExecuteNonQuery();
}
catch (System.Exception _ex)
{
//Error
myOracleTransaction.Rollback();
return false;
}
}
//All done
myOracleTransaction.Commit();