Difference between ADO and ADO.Net

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


Please Help Members By Posting Answers For Below Questions

Describe the disconnected architecture of ADO.NET’s data access model.

544


What is aggregate root?

494


How we can provide data to ado.net?

549


oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

1932


What is namespace in ado.net?

500






What are the disadvantages of using datalist?

512


What is dao and ado?

484


What do you mean by performing asynchronous operation using command object?

515


How to aggregating data across related tables?

554


Which is faster ado.net or linq?

518


What is the default provider in ado.net?

517


What is the role of clr?

531


How is entity framework different from ado.net?

488


What are the ado.net connection pooling parameters?

463


Explain the role of data provider in ado.net?

546