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
What is the provider being used to access oracle database?
how Sequence to connect and retrieve data from database using dataset?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What is the purpose of using adodb?
What is the maximum pool size in ado.net connection string?
What is datasource in ado.net?
Which is better entity framework or ado.net?
What is an ado?
How to add a check box or a dropdown list to a column in a datagrid?
Which is better ole db or odbc?
What is difference between executenonquery and executequery?
What is dao and ado?
Define the data provider classes that is supported by ado.net?
What is the use of Dataview?
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?