是否有底层协议的ODBC，OLEDB和放大器的差异; ADO.NET [英] Is there a difference in the underlying protocol for ODBC, OLEDB & ADO.NET
问题描述
在通信使用的典型系统，ODBC，OLEDB或ADO.NET中的一个SQL Server数据库，是底层的基本协议一样吗？难道这些系统基本上是客户端的问题？
When communicating to a SQL Server database using one of the typical systems, ODBC, OLEDB or ADO.NET, is the underlying basic protocol the same? Are all the differences between these systems basically just client side issues?
这一切都只是不同的TDS口味（表格数据流）转让？
Is this all just different flavors of TDS (Tabular Data Stream) transfer?
或者有实际不同的方式来谈论到数据库服务器，有这些协议之间的根本区别？
Or there actual different ways to talk to the database server and there are fundamental difference between these protocols?
推荐答案
ODBC，OLE DB和ADO.NET有不同的API /框架与数据库进行通信。例如，ADO在工作中的数据连接方式，主要是使用服务器端游标，而ADO.NET运行在断开连接的方式，从服务器把数据快速，在ADO.NET数据集对象的客户端缓存它。
ODBC, OLE DB and ADO.NET are different API/frameworks for communicating with the database. For example, ADO works on data in a connected fashion, primarily using server-side cursors, whereas ADO.NET operates on a disconnected fashion, pulling the data from the server quickly and caching it at the client in ADO.NET dataset objects.
引擎盖下，每种发送SQL命令到SQL Server通过TDS，并通过TDS接收数据备份。 OLE DB允许你去接近TDS的性能，而ODBC抽象了很多，提供了一致的接口许多不同的数据源。
Under the hood, each of these is sending SQL commands to SQL Server over TDS, and receiving data back via TDS. OLE DB allows you to get close to TDS for performance, whereas ODBC abstracts a lot to provide a consistent interface to many different data sources.
这篇关于是否有底层协议的ODBC，OLEDB和放大器的差异; ADO.NET的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
