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
Define Execute Scalar?
What are the different layers of ado.net?
Explain executenonquery?
What is difference in record set and dataset?
What is sqldatareader?
How would you connect to a database by using .NET?
Does entity framework use ado.net?
What is ado connection?
What is difference between dataset and datatable?
What is data relation?
Explain why edit is not possible in repeater?
differance between ADO vs ADO.Net?
What are the advantages using ado.net?
What are the differences between OLEDB and SQLClient Providers?
Which is faster sqldataadapter and sqldatareader?