ODP.NET是否需要Oracle客户端的安装 [英] Does ODP.NET require Oracle Client installation
问题描述
我不得不从.NET code连接的Oracle 11g数据库。为此目的，我阅读一些论坛帖子我承认，我需要Oracle客户端安装过之后安装ODP.NET钻。
I have to connect Oracle 11g DB from .NET code. For that purpose I installed ODP.NET bur after reading some forum posts I recognized that I need Oracle Client installation too.
是这样吗？我看到Oracle客户端具有约的大小2GB！我真的需要安装这样一个庞大的客户端才能够连接的Oracle数据块？
Is that true? I see that the Oracle Client has a size of ca. 2GB!!! Do I really need to install such a huge client only to be able to connect Oracle DBs?
推荐答案
亚历KEH从甲骨文在2013年8月说：
Alex Keh from Oracle in aug 2013 says:
管理ODP.NET被释放。它是目前Oracle数据库12c的一部分 客户。要使用管理ODP.NET，你必须下载并安装 DB客户端。从那里，你可以只提取管理ODP.NET 组装和安装文件。这些文件是小于10 MB，并且可以是 部署到任何目标机器。
Managed ODP.NET is released. It is currently part of the Oracle DB 12c client. To use managed ODP.NET, you have to download and install the DB client. From there, you can extract just the managed ODP.NET assembly and setup files. These files are less than 10 MB and can be deployed to any target machines.
目前，我们正在包装一个独立的管理ODP.NET释放 ODAC 12日发布，这将是更小。这将公布 OTN不久。
Currently, we are packaging a stand alone managed ODP.NET release and ODAC 12 release that will be much smaller. This will be released on OTN shortly.
如果你可以等几天，ODAC 12C会出在OTN上，你可以下载该版本。这将是我们的最新和最伟大 管理ODP.NET版本的
If you can wait a couple of days, ODAC 12c will be out on OTN and you can download that version. That will be our latest and greatest managed ODP.NET version
====
我们不打算把管理ODP.NET上的NuGet。我们认为，该 管理ODP.NET下载与ODAC将提供同样的好处 的NuGet在装配隔离和下载大小方面。
We do not plan to put managed ODP.NET on NuGet. We believe that the managed ODP.NET download with ODAC will provide the same benefits of NuGet in terms of assembly isolation and download size.
有一个线程讨论甲骨文是否应该提供管理 ODP.NET的NuGet支持。一旦你使用ODAC 12c的，我想知道 您的想法的NuGet是否支持仍然是必要的。 https://forums.oracle.com/thread/2559445
There's a thread discussing whether Oracle should provide managed ODP.NET NuGet support. Once you use ODAC 12c, I would like to know your thoughts on whether NuGet support is still necessary. https://forums.oracle.com/thread/2559445
PM> Install-Package Oracle.ManagedDataAccess
那么是什么问题呢？
基本上到现在为止，ODP.NET是一个.NET层会谈Oracle客户端.dll文件，一个小的事实，有很多含义：
So what is the problem anyway?
Basically up until now, ODP.NET was a .NET layer that talks to the Oracle client .dll files, a small fact that had many implications:
- 大安装空间（几百MB的）
- 坚韧部署到远程机器 - 需要在客户端上安装ODP.NET 机或部署大型文件
- 有好几个版本，32位/ 64位操作系统和应用程序时，挑战
- Large installation footprint (several hundreds of Mb)
- Tough deployment to remote machines - needs to install ODP.NET on client machine or deploy large files
- Challenging when working with several versions, 32bit/64bit os and applications
那么是什么呢？
在管理驱动程序基本上是一个单一的.dll文件与ODP.NET的净机实现。
这意味着没有Oracle客户端是必要的，而现在本土code是在幕后。的XCopy安装可以很容易地完成。
The managed driver is basically a single .dll file with a .Net native implementation of ODP.NET.
That means no Oracle Client is needed, and now native code is behind the scenes. XCopy installation can be done easily.
主要好处：
- 小尺寸
- 在编译为任何CPU，因此它可以在32位/ 64位操作系统的工作 应用流畅。易于管理的多个版本 同一台计算机
- 可部署的应用程序中的一个简单的参考 bin目录中。
- Small footprint
- Compiled as any cpu so it can work on 32bit/64bit OS and application smoothly. Easy to manage multiple versions on the same machine
- Can be deployed as a simple reference in the application bin directory.
那么，有什么收获？
- 并非所有的功能都支持（尽管其中大多数是...）你 可以找到更多的文档
- 命名空间是从改变 Oracle.DataAccess.Client到Oracle.ManagedDataAccess.Client
- 性能差异仍然不明确。 （老）原生code 始终执行非常有效，但在另一方面100％管理 code都有它的性能优势。
- Not all features are supported (although most of them are... ) you can find out more on the documentation
- Namespace is changed from Oracle.DataAccess.Client to Oracle.ManagedDataAccess.Client
- Performance differences are still not clear. (The old) Native code always perform very efficiently, but on the other hand 100% managed code has it's performance benefits.
请注意，Native- code ODP.NET仍然是非常可用。托管版本（至少目前如此），此外还要考虑到本机之一。
Please note that the Native-Code ODP.NET is still very much available. The managed version (at least for now) comes in addition to the native one.
参考文献：http://oracleatdotnet.blogspot.com.es/2013/07/odpnet-managed-driver-beta-2.html
的ODP.NET管理的驱动程序和未管理的驱动程序之间的差异 http://docs.oracle.com/html/E41125_02/intro004.htm
Oracle数据提供商的.NET功能 http://docs.oracle.com/database/121/ODPNT/features热媒＃ODPNT0007
这篇关于ODP.NET是否需要Oracle客户端的安装的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
