62,046
社区成员
发帖
与我相关
我的任务
分享
//该方法执行批量添加操作
public void Execute_In_Up_De(List<string> sql_list)
{
OracleConnection connection = null;
OracleCommand command =null;
OracleTransaction transaction=null;
try
{
using (connection = new OracleConnection(strcon))
{
connection.Open();
command = connection.CreateCommand();
transaction = connection.BeginTransaction();
command.Connection = connection;
command.Transaction = transaction;
//每一个item对象就为一条sql语句
foreach (string item in sql_list)
{
command.CommandText = item;
command.ExecuteNonQuery();
}
transaction.Commit();
}
}
catch (Exception ex)
{
if (transaction != null)
{
transaction.Rollback();
}
throw ex;
}
finally
{
if (connection != null)
{
connection.Close();
connection.Dispose();
}
}
}
//该方法执行时数据量小的情况下性能还可以,但 sql_list 里面数量上 万 时性能就慢下来
//想换成调用Oracle存储过程的方式,Oracle存储过程如何写才能达到最大优化求高人指点