oracle官方的托管驅動，發布只需一個6M多的dll，支持EF 支持分布式事務，使用步驟如下：?

1，Download ODP.NET, Managed Driver .zip file to a directory for staging the install.
2，Unzip the download to expand its contents into the target directory.
3，Run configure.bat to GAC and configure machine.config for ODP.NET, Managed Driver.
4，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.*).

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);}}} }

?

????

轉載于:https://www.cnblogs.com/jimcsharp/p/5278434.html

總結

以上是生活随笔為你收集整理的oracle全托管驱动Oracle.ManagedDataAccess的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。