Interested to Buy Any Domain ? << Click Here >> for more details...
What is ADO .NET and what is difference between ADO and ADO.NET?
- 7 Answers
- 14916 Views
- Ksb, I also Faced
- E-Mail Answers
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 the default timeout specified for "sqlcommand.commandtimeout" property?
What is ado full form?
How would you connect to database using .NET?
How to add an aggregate column?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
What is the difference between Dataset. clone and Dataset.copy?
How to create data relations?
How to load multiple tables into a dataset?
What is isolation?
What is connection in ado.net?
What is ado.net and its features?
Explain sqlconnection object?
What are the different execute methods of Ado.Net?
What is ado.net tutorial?
