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
Which method is used by command class to execute SQL statements that return single value?
What is linq and entity framework?
What is the meaning of object pooling?
Explain how to find the given query is optimised one or not?
Which name space is used to get assembly details?
What is the difference between OLEDB Provider and SqlClient?
What is the provider being used to access oracle database?
how can implement dropdownlist in particular of dataset when try to update?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
How to work with disconnected data - the dataset and sqldataadapter?
What is the use of ADO.NET and XML web services?
What is ado and dao?
What is ole db query?
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?
Define the executescalar method?