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