What is ADO .NET and what is difference between ADO and ADO.NET?

Answer Posted / pankaj

1. Business Model


ADO is Connection-oriented Models used mostly
ADO.NET is Disconnected models are used:Message-like Models.


2. Disconnected Access

ADO Provided by Record set.
ADO.NET Provided by Data Adapter and Data set

3. XML Support

ADO Limited
ADO.NET Robust Support

4. Connection Model

ADO Client application needs to be connected always to
data-server while working on the data, unless using
client-side cursors or a disconnected Record set

ADO.NET Client disconnected as soon as the data is
processed. DataSet is disconnected at all times.

5. Data Passing

ADO objects communicate in binary mode.
ADO.NET uses XML for passing the data.

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql command in ado net?

587


describe the dataset object in ado.net.

605


What is ado and dao?

616


How can we perform transactions in .net?

653


How to Read, Add, Update and Delete record in Entity Framework ?

651






What is the significance of CommandBehavior.CloseConnection ?

645


What is untyped dataset?

634


Why is ADO.NET serialization slower than ADO ?

668


What are the major challenges in accessing data from a database?

615


What is connection in ado.net?

614


Which method is used to sort the data in ADO.Net?

1615


Explain what are the steps to connect to a database?

592


What are the key features of ado.net?

755


What is a datagridview?

593


What is basic use of data view?

603