.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

What are major difference between classic ADO and ADO.NET

Q

What are major difference between classic ADO and ADO.NET ?

✍: Guest

A

Following are some major differences between both
? 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.
? Locking is not supported due to disconnected model.
? All data persist in XML as compared to classic ADO where data persisted in Binary format also.

2007-10-24, 5300👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML