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 ...
Get Sams Teach Yourself ADO.NET in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
