GZDBHelper连接Oracle数据库
Nuget安装
Oracle.ManagedDataAccess安装后 App.Config中 DbProviderFactories 节点会有一个Oracle的配置
<system.data>
<DbProviderFactories>
<remove invariant="Oracle.ManagedDataAccess.Client" />
<add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
</system.data>
连接Oracle数据库
private void btn_testOracle_Click(object sender, EventArgs e) { string Host = txt_Oracle_Host.Text; int Port = int.Parse(txt_Oracle_Port.Text); string DataBaseName = txt_Oracle_DataBaseName.Text; string UserID = txt_Oracle_User.Text; string Password = txt_Oracle_PWD.Text; // 生成数据库连接 var connStr = GZDBHelper.ConnectionStrings.BuildOracleConnectionString(Host, Port, DataBaseName, UserID, Password); // 创建数据库对象 var db = GZDBHelper.DatabaseFactory.CreateDatabase(connStr, GZDBHelper.ConnectionStrings.ProviderNames.ProviderNameForOracle, null); DataTable data = db.GetTable("SELECT * from JOBS;", "JOBS", null); }
GarsonZhang www.yesdotnet.com
如果是 .net standard 或者 .NET Core 则需要使用如下方法 创建数据库对象
var db = GZDBHelper.DatabaseFactory.CreateDatabase(Oracle.ManagedDataAccess.Client.OracleClientFactory.Instance, connStr, null);
GarsonZhang www.yesdotnet.com
效果
C# Oracle数据库连接字符串
return $"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST={Host})(PORT={Port}))(CONNECT_DATA=(SERVICE_NAME={DataBaseName})));User Id={UserID};Password={Password}";Host：服务器IP地址
Port：Oracle服务端口号，Oracle数据库默认端口号是：1521
UserID：用户名，和数据库相关，直接就对应了数据库
Password：密码
DataBaseName：服务器服务名称，在安装目录中 C:\app\user\product\11.2.-\dbhome_1\NETWORK\ADMIN
记事本打开
版权声明：本文为YES开发框架网发布内容,转载请附上原文出处连接
GZHelper YES开发框架
