Benefits of ADO.NET

You may wonder why Microsoft felt it necessary to start over again, putting ADO “out to pasture” and moving on to ADO.NET. Wasn't ADO good enough? It isn't that ADO was not good enough; rather, developer's needs have changed.

The biggest difference between ADO.NET and ADO is that ADO.NET was constructed, from the ground up, to support disconnected manipulation of data. With ADO.NET, you read through the data using a forward-only, read-only stream. If you need to work with a set of data, you retrieve a cached version of the data you need, work with it in a disconnected environment, and then send updates back when you're done.

Certainly, ADO's connected model requires less thought on the part of the developer. You connect to ...

Get ASP.NET Developer's JumpStart 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.