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

What are the advantages using ado.net?

537


Which ado.net object is very fast in getting data from the database?

652


Which architecture does Datasets follow?

586


Define ado.net?

577


What is the difference between typed and untyped dataset?

510






What is the advantage of ado.net?

549


What is oledb driver?

499


What is a dataview?

539


What is untyped dataset?

541


What is the use of adodc?

530


What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

585


What is dataset and datatable in ado.net?

503


What is Serialization in .NET? what are the types of Serialization?

555


Which method in OLEDBAdapter is used to populate dataset with records?

561


Define Execute Reader?

592