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
Define executenonquery?
What is ado.net tutorial?
What are the differences between OLEDB and SQLClient Providers?
What is variable view?
Name which operations can you not perform on an ado.net dataset?
What are the disadvantages of using datalist?
Explain what are acid properties?
Explain how can we load multiple tables in to dataset?
Define table relations?
Describe the command object and its method.
Explain the various objects in dataset.
What is connection pooling and what is the maximum pool size in ado.net connection string?
What is dao and ado?
What is datatable in ado.net?
What is the purpose of using adodb?