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 the difference between statement and preparedstatement interface?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
What is the difference between linq and ado.net?
What is the use of Dataview?
What Is Difference Between Ado And Ado.net?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
What is ado or jdbc?
What is the meaning of executenonquery?
What are the different methods by which we can populate a dataset?
List the 4 common ado.net namespaces?
How to read data with the sqldatareader ?
What is difference between Dataview and Datatable?
Describe connection object in ado.net
What is the meaning of object pooling?
How is it possible to get 2 tables of data at a time by using data reader?