visual-studio-2010 - 从 Visual Studio 2010 连接到 Oracle

Question

我想使用 ODBC 从 Visual Studio 2010 连接到 Oracle 11g 数据库。我无法使用 ODP.NET 进行连接，所以我想尝试使用 ODBC。有人可以告诉我这涉及哪些步骤吗？

Answer 1

假设您使用的是 C#，

您必须添加对 的引用System.Data.OracleClient.dll 在你的项目中

这是一些示例样板代码，

using System.Data.OracleClient;

static private string GetConnectionString() 
{ 
   // To avoid storing the connection string in your code, 
   // you can retrieve it from a configuration file. 
   return "Data Source=myserver.server.com;Persist Security Info=True;" + 
      "User ID=myUserID;Password=myPassword;Unicode=True"; 
}

// This will open the connection and query the database
static private void ConnectAndQuery() 
{ 
   string connectionString = GetConnectionString(); 
   using (OracleConnection connection = new OracleConnection()) 
   { 
       connection.ConnectionString = connectionString; 
       connection.Open(); 
       Console.WriteLine("State: {0}", connection.State); 
       Console.WriteLine("ConnectionString: {0}", 
                  connection.ConnectionString); 

       OracleCommand command = connection.CreateCommand(); 
       string sql = "SELECT * FROM MYTABLE"; 
        command.CommandText = sql; 

       OracleDataReader reader = command.ExecuteReader(); 
       while (reader.Read()) 
       { 
            string myField = (string)reader["MYFIELD"]; 
            Console.WriteLine(myField); 
       }
   }
}

来源 - http://www.codeproject.com/KB/database/C__Instant_Oracle.aspx