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
What is ado.net tutorial?
How to aggregating data across related tables?
What is a non query?
What is XML serialization
Explain ado.net features?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
How to check if a datareader is closed or opened? IsClosed()
What is the difference between dataset and datatable?
What are the pre-requisites for connection pooling?
What are the methods of XML dataset object?
Where is adodb dll located?
What does adodb stand for?
What is ado asp?
What does executenonquery () method return?
What is execute scalar in ado.net?