c# 访问oracle数据库

使用到

Oracle.ManagedDataAccess.dll程序集，可以轻松实现对oracle数据库的操作

一、引入相应的程序集

项目引入Oracle.ManagedDataAccess.dll程序集、并在文件头部引入名称空间

using Oracle.ManagedDataAccess.Client;

二、连接数据库

下面是通过配置文件存储数据库的连接字符串、然后再进行连接

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />
  </startup>
  <connectionStrings>
    <add name="ConnDatabase"
    connectionString="Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = 168.168.202.93)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = syhh)));User ID=hs_asset;Password=hundsun;" />
    <!--connectionString="server=(localdb)\MSSQLLocalDB;integrated security=SSPI;database=testDataBase" />-->
  </connectionStrings>   //该出是数据库连接信息
</configuration>

下面是在后台程序中写的连接函数，注意ConnectionStringSettings的名称空间为using System.Configuration;别忘了引入

       private static OracleConnection GetDatabaseConnection(string name)
        {
            ConnectionStringSettings settings =
            ConfigurationManager.ConnectionStrings[name];

            OracleConnectionconn = new OracleConnection(settings.ConnectionString);
            return (OracleConnection)conn;
            //string connString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.115)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=testDatabase)));User ID=hello;Password=hello;";
            //OracleConnection con = new OracleConnection(connString);
            //return con;
        }

以上便实现了连接192.168.2.115端口号为1521上的数据库testDatabase