c# 插入 oracle,Oracle批量插入在C#中的应用

void SetUserReportResult(int[] reportId, bool isReceive, stringresult)

{if (reportId == null)throw new ArgumentNullException("reportId");

result= result.Left(80);string sql = "update msg_user_receive_report set isreceive=" + Convert.ToInt32(isReceive) + ",";if (!isReceive)

sql+= "ukey=‘0‘,";var resultParam = "null";if (result != null)

resultParam= "‘" + result.Replace("‘", "‘‘") + "‘";

sql+= "result=" + resultParam + ",retrycount=retrycount+1,userreceivetime=sysdate where id=:reportId";

Stopwatch watch;using (var connection = this.CreateConnection())

{using (var command =connection.CreateCommand())

{var size =reportId.Length;

command.CommandText=sql;

command.ArrayBindCount=size;

command.Parameters.Add(new OracleParameter("reportId", OracleDbType.Int32) { Value =reportId });

connection.Open();

watch=Stopwatch.StartNew();var c =command.ExecuteNonQuery();

watch.Stop();

}

connection.Close();

}

Trace.TraceInformation("Data.SetUserReportResult,watch=" +watch.ElapsedMilliseconds);

}

Oracle批量插入在C#中的应用

标签：seconds   div   code   watch   try   acl   ndt   ram   receive

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://www.cnblogs.com/rengke2002/p/7462516.html