.net的替代Oracle驱动程序 [英] Alternative Oracle drivers for .net

问题描述

我必须在C＃中开发一个从Oracle DB检索一些数据的工具。由于我们的IT支持在安装Oracle客户端时遇到一些麻烦，我希望能够连接到数据库而不安装客户端。
这个想法是只是安装（也许注册）一个额外的库和应用程序。

I have to develop a tool in C# that retrieves some data from an Oracle DB. Since our IT support is having some trouble with installing the Oracle client, I want to be able to connect to the database without the client installed. The idea is to just install (and maybe register) an additional library together with the app.

Oracle客户端存在哪些替代方法，优点和缺点？

Which alternatives to the Oracle client exist, and what are their pros and cons?

这是一个小应用程序（1个表单，2或3个查询，结果显示在DataGrid中，可能不超过10-20个数据集），但我也对可扩展性问题感兴趣，因为我们也可能从Oracle客户端移除更大的未来项目。

This is for a small application (1 form, 2 or 3 queries, the result displayed in a DataGrid, probably no more than 10-20 data sets), but I am also interested in scalability issues, since we may also move away from the Oracle client with bigger future projects.

当然，免费软件解决方案会很好，但我们不限于此。

Of course a freeware solution would be nice, but we are not limited to that.

推荐答案

Oracle ODP.Net驱动程序。您想使用哪个版本？

There are a couple different flavors of the Oracle ODP.Net driver. Which version are you trying to use?

这听起来像您想要的Oracle 11g ODAC 11.1.0.6.21与Xcopy部署，允许您部署Oracle即时客户端和ODP.Net驱动程序只是通过复制几个DLL和注册它们。这不需要完整的Oracle客户端安装。

It sounds like you want the Oracle 11g ODAC 11.1.0.6.21 with Xcopy Deployment, which allows you to deploy the Oracle Instant Client and the ODP.Net driver just by copying a few DLLs over and registering them. That doesn't require a full-blown Oracle client installation.

这篇关于.net的替代Oracle驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！