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 are all the different authentication techniques used to connect to MS SQL Server?
How to identify the updated rows in a dataset?
What is the default provider in ado.net?
What is serialization and de-serialization in .net?
What is ado data control?
What are the 3 major types of connection objects in ado.net?
How to load multiple tables into a dataset?
What are the parameters that control most of connection pooling behaviours?
What is the difference between the clone() and copy() methods of the dataset class?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What is datatable in ado.net?
What is difference between datatable and dataset?
Which method in OLEDBAdapter is used to populate dataset with records?
What does ado stand for?
Explain the dataadapter class in ado.net?