Difference between classic ADO and ADO.NET

Question

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

nallya · Answer

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

Satyapriya Nayak · Answer

http://dotnetguts.blogspot.in/2007/07/difference-between-ado-and-adonet.html

Santhosh Kumar Jayaraman · Answer

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. http://en.wikipedia.org/wiki/Comparison_of_ADO_and_ADO.NET