What is the main difference between ADO and ADO.Net

Answer Posted / jyoti

ADO was a connected data access model, which means that when
a connection to the database is made, the connection remains
open until the application is closed.

ADO.NET is disconnected database access model, which means
when an application interacts with the database, the
connection is opened to serve the request of the
application, and is closed as soon as the request is completed.

All data is presented in XML, as compared to ADO.

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which method is used by command class to execute SQL statements that return single value?

741


What is linq and entity framework?

675


What is the meaning of object pooling?

811


Explain how to find the given query is optimised one or not?

689


Which name space is used to get assembly details?

684






What is the difference between OLEDB Provider and SqlClient?

694


What is the provider being used to access oracle database?

698


how can implement dropdownlist in particular of dataset when try to update?

2504


How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

775


How to work with disconnected data - the dataset and sqldataadapter?

707


What is the use of ADO.NET and XML web services?

768


What is ado and dao?

696


What is ole db query?

725


What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

701


Define the executescalar method?

659