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

Define executenonquery?

710


What is ado.net tutorial?

705


What are the differences between OLEDB and SQLClient Providers?

789


What is variable view?

681


Name which operations can you not perform on an ado.net dataset?

722


What are the disadvantages of using datalist?

720


Explain what are acid properties?

774


Explain how can we load multiple tables in to dataset?

708


Define table relations?

751


Describe the command object and its method.

760


Explain the various objects in dataset.

745


What is connection pooling and what is the maximum pool size in ado.net connection string?

732


What is dao and ado?

716


What is datatable in ado.net?

732


What is the purpose of using adodb?

704