Difference between classic ADO and ADO.NET

Sharad Gupta

What are main difference between classic ADO and ADO.NET?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago
http://dotnetguts.blogspot.in/2007/07/difference-between-ado-and-adonet.html
nallya14y ago
Following are some major differences between both :-

• In ADO we have recordset and in ADO.NET we have dataset.

• In recordset we can only have one table. If we want to accommodate more than one tables we need to do inner join and fill the recordset. Dataset can have multiple tables.

• All data persist in XML as compared to classic ADO where data persisted in Binary format also.

For another diffrences related to ADO Refer:

http://onlydifferencefaqs.blogspot.in/2012/07/adonet-difference-faqs-1.html

	ADO	ADO.NET
Business Model	Connection-oriented Models used mostly	Disconnected models are used:Message-like Models.
Disconnected Access	Provided by Record set	Provided by Data Adapter and Data set
XML Support	Limited	Robust Support
Connection Model	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.
Data Passing	ADO objects communicate in binary mode.	ADO.NET uses XML for passing the data.
Control of data access behaviors	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.
Design-time support	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.