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
Which object needs to be closed?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What are the differences between OLEDB and SQLClient Providers?
What is dataadapter in ado.net?
What are basic methods of dataadapter?
Explain how to pass multiple tables in datasets simultaneously?
What are the features of ado.net?
What is XML serialization
What are two important objects of ADO.Net?
What is datatable in ado.net?
Which keyword is used to accept variable number of parameters?
What is oledb connection?
Which object of ado contains datarow datacolumn collection?
Which property is used to check whether a DataReader is closed or opened?
What is ole2 format?
