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 identify the controls which can be used for binding data?
What are the rules to implement connection pooling?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is ado.net connection?
What is the difference between Datareader and Dataset?
Why do we use sqldataadapter?
Is entity framework better than ado.net?
How to work with disconnected data - the dataset and sqldataadapter?
Define Execute Scalar?
What is a sqldataadapter?
Can we connect two dataadapters to same data source using single connection at same time?
What are the important features of ado.net 2.0?
How would you connect to a database by using .NET?
What are the core objects of ADO.NET?
What is the difference between dataset and datatable?