C#VS 2015 Oracle连接示例 [英] C# VS 2015 Oracle Connection Example
问题描述
第1步。 VS 2015管理Nuget软件包安装"Oracle.ManagedDataAccess"
Step 1 . VS 2015 Manage Nuget Packages install "Oracle.ManagedDataAccess"
步骤2。 C#代码
使用System;
使用System.Collections.Generic;
使用System.Linq;
使用System.Text;
使用System.Threading.Tasks;
使用Oracle.ManagedDataAccess.Client;
使用Oracle.ManagedDataAccess。类型;
使用System.Data;
$
命名空间OracleConnectExample
{
 课程计划
  {
      static string x =" Massachusetts Institute of ;;
      static string y =" Technology"; $
      static void Main(string [] args)
      {
          OracleConnection conn = new OracleConnection();
conn.ConnectionString =" Data Source =(DESCRIPTION =" +"(ADDRESS =(PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))"+
"(CONNECT_DATA =" +
; "(SERVER = DEDICATED)" +
"( SERVICE_NAME = orcl)" +
")" +
  ; "); User Id = system;密码= SeCret1453;" ;;
          conn.Open();
          string exq1 ="插入A1DATA(ANAME,ASURNAME)值(:1,:2)" ;;
          OracleCommand command = new OracleCommand(exq1,conn);
          command.Parameters.Add(new OracleParameter(" 1",x));
          command.Parameters.Add(new OracleParameter(" 2",y));
          command.ExecuteNonQuery();
          command.Connection.Close();
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Oracle.ManagedDataAccess.Client;
using Oracle.ManagedDataAccess.Types;
using System.Data;
namespace OracleConnectExample
{
class Program
{
static string x = "Massachusetts Institute of ";
static string y = "Technology";
static void Main(string[] args)
{
OracleConnection conn = new OracleConnection();
conn.ConnectionString = "Data Source = (DESCRIPTION = " + "(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))" +
"(CONNECT_DATA = " +
"(SERVER = DEDICATED)" +
"(SERVICE_NAME = orcl)" +
")" +
");User Id = system; Password = SeCret1453;";
conn.Open();
string exq1 = "insert into A1DATA (ANAME,ASURNAME) values(:1,:2)";
OracleCommand command = new OracleCommand(exq1, conn);
command.Parameters.Add(new OracleParameter("1", x));
command.Parameters.Add(new OracleParameter("2", y));
command.ExecuteNonQuery();
command.Connection.Close();
}}}
如何加速?
推荐答案
Hi Halil Baybars Saltik,
Hi Halil Baybars Saltik,
感谢您在此发帖。
对于您的问题,s 单个插入始终是慢一点您可以开始处理数组中的数据,从源系统中选择一批数据并将数组加载到目标。
有关详细信息,请参阅< a href ="http://www.oracle.com/technetwork/issue-archive/2009/09-sep/o59odpnet-085168.html">
文章。它对u se数组绑定有很好的解释,可以减少网络往返次数并提高性能。
For more details, please refer to the article. It has a good explanation about use array binding to reduce network round-trips and increase performance.
我希望这会有所帮助。
最好的问候,
Wendy
这篇关于C#VS 2015 Oracle连接示例的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!