Comparision between ADO and ADO.net?


Comparision between ADO and ADO.net?


ADO
Connection-oriented Models used mostly


ADO.NET
Disconnected models are used:Message-like Models.
Provided by Record set
Provided by Data Adapter and Data set
Limited
Robust Support
Client application needs to be connected always to data-server while working on the data, unless using client-side cursors or a disconnected Record set
Client disconnected as soon as the data is processed. DataSet is disconnected at all times.
ADO objects communicate in binary mode.
ADO.NET uses XML for passing the data.
Includes implicit behaviors that may not always be required in an application and that may therefore limit performance.
Provides well-defined, factored components with predictable behavior, performance, and semantics.
Derives information about data implicitly at run time, based on metadata that is often expensive to obtain.
Leverages known metadata at design time in order to provide better run-time performance and more consistent run-time behavior.

No comments:

Post a Comment