Answer Posted / sandyni
Following are some major differences between both
1.As in classic ADO we had client and server side cursors
they are no more present in ADO.NET. Note it's a
disconnected model so they are no more applicable.
2. Locking is not supported due to disconnected model.
3. All data persist in XML as compared to classic ADO where
data persisted in Binary format also.
4. Ado.net uses Dataset where as Ado uses RecordSet.
5.Ado.Net uses Dataproviders where as classic Ado uses COM
model.
6.Ado.net can able to works on multiple tables where as Ado
can works on only on etable.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is typed dataset ?
What are dcl commands?
What is data relation?
What is ado asp?
How do you update database through dataset?
Which object of ado contains datarow datacolumn collection?
What is ole in excel?
What is dao and ado?
Is ado.net an orm?
What is the difference between Dataset. clone and Dataset.copy?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
How can we load multiple tables in a dataset?
What is the return type of executescalar?
What are the advantages and drawbacks of using ado.net?
differences between ADO and ADO.NET