What is the main difference between ADO and ADO.Net
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 are the ado.net components?
Why do we serialize data?
What is defaultview in datatable?
What are two types of transaction supported by ado.net?
The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
What is linq and entity framework?
What is maximum pool size in ado.net connection string?
What is ado object model?
What are the Data providers in ADO.Net?
What is difference between datagridview and datagrid control in winforms?
What does sqldatareader return?
What is the difference between Data adaptor and Data set?
Why do we use sqldataadapter?
Give few examples of datareader that is used in different dataproviders.
What is a control toolbox?