ADO is the object-based interface that provides a logical set of objects you can access from code. These objects are:
Object |
Functionality |
Connection |
Manages the connection with the data source |
Command |
Defines the commands that will be executed against the data source |
Recordset |
Contains the data that is retrieved from the data source |
These objects present an interface in the form of properties and methods that can be queried and manipulated. ADO was specifically developed to be small, lightweight, fast, and feature complete – everything you need when you are programming either for the database applications or the Internet.
An important thing in ADO is that the objects in this model are not dependant on one another. This means that you can create instances of objects independently of one another, for example, you can create a Recordset object without creating a connection object. Unlike the older technologies, ADO is more flexible, ADO code is easier to write, read and maintain. ADO is built on top of OLE DB and is capable of accessing any sort of data that is wrapped and exposed by an appropriate OLE DB provider.
Comments