ado.net mysql 事务_请各位高人评价一下这个批量执行数据库插入语句加事务！

这个方法就是想实现批量执行插入语句 然后加入事务的机制

///

/// 执行sql语句事加入事务机制

///

/// 要执行sql的集合

public static void ExcuteForNonQuery(List sqllist)

{

using (OracleConnection conn = new OracleConnection("连接字符串"))

{

conn.Open();

OracleTransaction transnction = conn.BeginTransaction();

try

{

OracleCommand cmd = conn.CreateCommand();

cmd.Transaction = transnction;

cmd.CommandType = CommandType.Text;

foreach (string var in sqllist)

{

cmd.CommandText = var;

cmd.ExecuteNonQuery();

}

transnction.Commit();

transnction.Dispose();

cmd.Dispose();

}

catch (OracleException ex)

{

transnction.Rollback();

throw ex;

}

finally

{

//关闭数据库连接

if (conn.State != ConnectionState.Closed)

{

conn.Close();

conn.Dispose();

}

}

}

}