oracle全托管驱动Oracle.ManagedDataAccess

最新推荐文章于 2021-07-28 10:22:22 发布

weixin_30455067

最新推荐文章于 2021-07-28 10:22:22 发布

阅读量312

点赞数

文章标签：数据库 c#

原文链接：http://www.cnblogs.com/ly303550688/archive/2013/01/31/2887104.html

版权

终于见到了oracle官方的托管驱动，发布只需一个6M多的dll，支持EF 支持分布式事务

附：

Download ODP.NET, Managed Driver .zip file to a directory for staging the install.
Unzip the download to expand its contents into the target directory.
Run configure.bat to GAC and configure machine.config for ODP.NET, Managed Driver.
Create a new Visual Studio 2010 console application project for C#.
Add Oracle.ManagedDataAccess.dll as a reference to the project.

Replace the contents of Program.cs with the following C# code. Notice that the namespace of ODP.NET, Managed Driver (Oracle.ManagedDataAccess.*) is different from the namespace of ODP.NET, Unmanaged Driver (Oracle.DataAccess.*).

// C#
using System;
using Oracle.ManagedDataAccess.Client;
using Oracle.ManagedDataAccess.Types;

namespace Connect
{
  class Program
  {
    static void Main(string[] args)
    {
      try
      {
        // Please replace the connection string attribute settings
        string constr = "user id=scott;password=tiger;data source=oracle";

        OracleConnection con = new OracleConnection(constr);
        con.Open();
        Console.WriteLine("Connected to Oracle Database {0}", con.ServerVersion);
        con.Dispose();

        Console.WriteLine("Press RETURN to exit.");
        Console.ReadLine();
      }
      catch (Exception ex)
      {
        Console.WriteLine("Error : {0}", ex);
      }
    }
  }
}