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 ado and dao?
Is entity framework better than ado.net?
What is shadow copy?
Which is the feature of ado.net?
What is the difference between data reader and data adapter?
Is datareader faster than datatable?
What is sqldatasource?
Explain how can we load multiple tables in to dataset?
Explain ODP.net
Which is faster entity framework or ado.net?
What is disconnected architecture in ado.net?
What is a dataview?
What is the return type of executescalar?
What is the difference between oledb sql server and oledbdotnet provider?
How can we perform transactions in .net?
