Interested to Buy Any Domain ? << Click Here >> for more details...
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 concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What is the use of data grid?
What is ole2 format?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
What is ambient transaction?
What is ado.net connection?
can we create synonymn in ms access,sql server,my sql if so explain me with example
What we do with the object of ado.net dataset after using it?
What is a dynaset in access?
What are the different row versions available in table?
What are the steps you will take to improve performance? Will you use dataset or datareader?
What are the main differences between classic ado and ado.net?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
What is the use of ADO.NET and XML web services?
What are the advantages of ado.net?
