What is the main difference between ADO and ADO.Net
- 4 Answers
- 9044 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / babina
The old ADO (ActiveX Data Object) has evolved to ADO.NET in
the .NET Framework. The ADO.NET object is a lightweight
object. The ADO Recordset was a huge object in ADO. It
provided the ability to support multiple types of cursors.
It provided fast lightweight "firehose" cursor and also
supported a disconnected client-side cursor that supported
tracking, optimistic locking, and automatic batch updates of
a central database. However, all of this functionality was
difficult to customize.
ADO.NET breaks the functionality of the ADO object to
multiple classes, thereby allowing a focused approach to
developing code. The ADO.NET DataReader is equivalent to the
"firehose" cursor. The DataSet is a disconnected cache with
tracking and control binding functionality. The DataAdapter
provides the ability to completely customize how the central
data store is updated with the changes to a DataSet.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is ado oledb and odbc?
Define partial class?
What are the ado.net components?
What is the difference between ado.net and oledb?
What is the difference between SqlCommand and SqlCommandBuilder?
Explain advantages of ado.net?
Give an example that shows how to execute a stored procedure in ado.net?
What does executereader return?
Is it possible to edit data in Repeater control?
What is connection in ado.net?
What are the parameters that control most of connection pooling behaviors?
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?
Why is stored procedure used in ado.net?
What are ado.net objects?
Is ado.net an orm?
