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 fill method in ado.net?

749


What are advantages of microsoft-provided data provider classes in ado.net?

795


Which control of the BindingNavigator returns the current position within the data source?

957


What is the advantage of ado.net?

788


What does ado stand for in ado.net?

746


Which ado.net object is very fast in getting data from the database?

891


What is ado data control?

780


What is connection in ado.net?

741


What are the advantages and disadvantages of using datalist?

757


Which database is the ado.net?

766


What is the difference between Data adaptor and Data set?

823


Describe briefly an ADO.NET Dataset ?

787


Define ado.net?

826


What providers does Ado.net uses?

803


What is ado control?

741