什么是 Oracle 客户端？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2870755/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is an Oracle Client?
提问by Zacky112
I'm from MySQL background and am new to Oracle. I want to know
我来自 MySQL 背景并且是 Oracle 的新手。我想知道
- What is meant by Oracle Client?
- What is its use?
- What is its equivalent in MySQL ?
- Oracle 客户端是什么意思？
- 它的用途是什么？
- 它在 MySQL 中的等价物是什么？
Thanks
谢谢
回答by Will Marcouiller
What is meant by Oracle Client?
Oracle 客户端是什么意思？
and
和
What is its use?
它的用途是什么？
In this context, a client is a class library (DLL) that allows you to connect remotely to the underlying database of an application. A client, always within the same context, can also be called a .NET Data Provider.
在这种情况下，客户端是一个类库 (DLL)，它允许您远程连接到应用程序的基础数据库。始终处于同一上下文中的客户端也可以称为.NET Data Provider.
You may have multiple data providers based on the underlying database engine with which you're working.
根据您正在使用的底层数据库引擎，您可能有多个数据提供者。
There was System.Data.OracleClient(deprecated), provided by Microsoft.
有System.Data.OracleClient（已弃用），由 Microsoft 提供。
There is Oracle.Data.Client, which is actually the best ever built Oracle Client, or Oracle .NET Data Provider. You may also download the latest Oracle 11g Data Provider for .NET.
有Oracle.Data.Client，它实际上是有史以来最好的 Oracle 客户端或 Oracle .NET 数据提供程序。您也可以下载最新的Oracle 11g Data Provider for .NET.
So, when accessing the Oracle underlying database, make sure your work with this provider, proper for your version of Oracle, and start doing ADO.NETwith your favorite database! =P
因此，在访问 Oracle 底层数据库时，请确保您使用该提供程序，适合您的 Oracle 版本，并开始ADO.NET使用您最喜欢的数据库！=P
There are also some other tools that you can work with that will ease your data access code pain, such as Enterprise Libraryor NHibernate, both are frameworks to basically accessing databases.
您还可以使用其他一些工具来减轻数据访问代码的痛苦，例如Enterprise Library或NHibernate，它们都是基本访问数据库的框架。
Enterprise Librarycan do even more then that!
Enterprise Library可以做得更多！
And NHibernateis an ORM (Object/Relation Mapping)tool that can work just very fine with Oracle.
并且NHibernate是一个ORM (Object/Relation Mapping)可以很好地与 Oracle 配合使用的工具。
Remember though, always use Oracle.Data.Clientnamespace in the Oracle.DataAccess.dllassembly.
但请记住，始终Oracle.Data.Client在Oracle.DataAccess.dll程序集中使用命名空间。
What is its equivalent in MySQL ?
它在 MySQL 中的等价物是什么？
As the equivalence for MySQL, I guess it would be MySQL Connector/NET.
作为 MySQL 的等价物，我想它是MySQL Connector/NET.
回答by Stellios
It is the Oracle binaries installed that allow communication with the Oracle database. It can be using SQL*Plus, JDBC (type II or IV) or OCI (Oracle Call Interface).
安装的 Oracle 二进制文件允许与 Oracle 数据库进行通信。它可以使用 SQL*Plus、JDBC（类型 II 或 IV）或 OCI（Oracle 调用接口）。
回答by Greg Olmstead
Its a piece of software that allows a remote computer to talk to Oracle. If you were to write a piece of software that communicated with the database, you would use the Oracle Client to facilitate that communication
它是一款允许远程计算机与 Oracle 对话的软件。如果您要编写一个与数据库通信的软件，您将使用 Oracle 客户端来促进该通信
