Answer Posted / guneetinder singh
1. ADO used connected data usage, while ADO.net used
disconnected data environment.
2. ADO used OLE DB to access data and is COM-based, while
ADO.net uses XML as the format for transmitting data to and
from your database and web application.
3. In ADO, Record set, is like a single table or query
result, while in ADO.net Dataset, can contain multiple
tables from any data source.
4. In ADO, it is sometime problematic because firewall
prohibits many types of request, while in ADO.net there is
no such problem because XML is completely firewall-proof.
| Is This Answer Correct ? | 28 Yes | 2 No |
Post New Answer View All Answers
How to pass values into a datatable?
Can you explain how to enable and disable connection pooling?
What is the current version of entity framework?
What is the usage of the dataset object in ado.net?
What is ado.net components?
What are the types of databinding?
How can we add relation between tables in a dataset?
What is the difference between OLEDB Provider and SqlClient?
What is ado control?
What are the namespaces used in ado.net for data access?
What are the namespaces used in ADO.Net to connect to a database?
What is a dynaset in access?
What are the uses of Stored Procedure?
What does sqldatareader return?
Explain executenonquery?