使用到
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