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 recordset?
What is the maximum pool size in ado.net connection string?
What are the Data providers in ADO.Net?
Describe the disconnected architecture of ADO.NET’s data access model.
How can we add relation between tables in a dataset?
How does ado.net work?
Describe connection object in ado.net
Explain the difference in record set and dataset?
Can datareader hold data from multiple tables?
What is data reader in ado.net?
What does executenonquery () method return?
Explain the advantages and disadvantages of using datalist?
Why is stored procedure used in ado.net?
Explain ado.net features? Benefits? Drawbacks?
What is dao and ado?