What are the main differences between ADO and ADO.Net?

Posted By: Avi

Date: 4 September 2009 06:56:11 AM

Answer:

1) ADO works only with connected architecture while ADO.Net works in both connected as well as disconnected architecture.

2) ADO objects communicate in binary mode while ADO.Net uses XML for passing the data.

3) In ADO, a recordset is used to hold data which looks like a single table. If a recordset is to contain data from multiple database tables, it must use a JOIN query, which assembles the data from the various database tables into a single result table. While in ADO.Net we can use a dataset which can have a collection of one or more tables.

Posted By: eTechPlanet

Date: 4 September 2009 06:56:11 AM

Post a better Answer if you have

Name*

E-mail* (Will show your Gravatar icon)

Website

Country

Notify me when new Answers are added

Enter the text as shown in the image

Does ADO.NET support cursors?

Category: ADO.Net

Date: 10/13/2010 9:30:48 AM

Write the Connection String used in ADO.Net to connect with SQL Server database?

Connection String with SQL Server Security Authentication (needs to include UserID and Password of d....

Category: ADO.Net

Date: 12/2/2009 12:23:20 AM

Explain Connection String used in ADO.Net?

When .Net application connects to a database or a data file, ADO.Net uses a connection provider spec....

Category: ADO.Net

Date: 12/2/2009 12:04:03 AM

What is the use of command objects?

This object represents an SQL statement that is executed while connected to the database. Following ....

Category: ADO.Net

Date: 10/15/2009 5:03:07 AM

What are the various methods provided by the dataset object to generate XML?

DataSet object provides following methods to generate XML: 1) ReadXML Reads a XML schema and data i....

Category: ADO.Net

Date: 10/8/2009 3:49:37 AM

View All Questions >>

Signup for our weekly email newsletter

Submit Content