创建oracle数据库、多个方法 如何用事务处理

[csharp_弈剑听雨]

如题:1.多个sql语句创建oracle数据库 用户如何用事务
2.多个方法函数如何用net事务，多个方法要同时成功执行，一个出错全部回滚
附事务方法
/// <summary>
/// 事物执行多条sql语句
/// </summary>
/// <param name="sqlList"></param>
/// <returns></returns>
public static ReturnResult ExecuteTran(List<string> sqlList)
{
ReturnResult ret = new ReturnResult();
using (OracleConnection con = new OracleConnection(ConnectionString))
{
con.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = con;
OracleTransaction tran = con.BeginTransaction();
cmd.Transaction = tran;
try
{
for (int i = 0; i < sqlList.Count; i++)
{
string sql = sqlList[i].ToString();
if (sql.Trim().Length > 1)
{
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
}
tran.Commit();
ret.RetResult = true;
}
catch (OracleException ex)
{
tran.Rollback();
ret.RetResult = false;
ret.Message = ex.Message;
}
finally
{
con.Close();
}
return ret;
}
}

[tiger8903084937]

学习下...