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
How to copy the contents from one table to another table and how to delete the source table in ado.net?
What are the Features and disadvantages of dataset
Command objects uses, purposes and their methods.
What is a column variable?
How can we add relation between tables in a dataset?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Which is faster dataset or datareader?
What is ado recordset?
Explain the various objects in dataset.
What is the difference between SqlCommand and SqlCommandBuilder?
What is aggregate root?
What is the default Timeout for SqlCommand.CommandTimeout property?
What is dataset object? Explain the various objects in dataset.
How do you update a dataset in ado.net?
What are the major difference between classic ADO and ADO.NET?