ADO.NET Versus ADO
The relationship between ADO and ADO.NET is analogous to the one between Active Server Pages (ASP) and ASP.NET. Many of the object and method names are similar, but behind the curtains everything has been redesigned and improved.
For instance, the ADO data model was based on the recordset object. In essence, the recordset was a spreadsheet of data in memory. You were very limited in what you could do with a recordset of data. It was difficult to do advanced data filtering or combine two recordsets. Additionally, although it is possible to transmit an ADO recordset to a remote server, you must configure all firewalls between the two servers to enable the proprietary ports required for COM martialing.
Additionally, the remote ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access