Common ways to Access databases

ODBC (Open Database Connectivity):

is a set of database access standards developed and defined by Microsoft, known as Open database system interconnection. ODBC provides a programming interface that allows access to a variety of database management systems using an ODBC application, such as Access, MySQL, DB2, FoxPro, SQL Server, and Oracle, and is the first data access technology to access different relational databases using SQL. With ODBC applications, you can manipulate different databases with a single command, and developers only need to add ODBC drivers for different applications.
　　
DAO (Data Access Objects):

Unlike ODBC, which is intended for C + + programmers, it is a simple method of data access that Microsoft provides to Visual Basic developers, but does not provide remote access functionality.

RDO (Remote Data Object):

When using DAO to access different relational databases, the jet engine had to convert the commands between DAO and ODBC, resulting in degraded performance, and the advent of RDO (Remote Data Objects) was a logical occurrence.
　　
OLE DB (Object linking and embedding DataBase):

OLE DB (Object linking and Embedding database) as more and more data is stored in a non-relational format, a new architecture is needed to provide a seamless connection between this application and the data source, and the COM-based (Component object Model) Ole DB emerges.
　　
ADO (ActiveX Data Object):

ADO based on OLE DB is simpler, more advanced, and more suitable for Visual Basic programmers, while eliminating many of the drawbacks of OLE DB and instead is a trend in Microsoft's technology development.

ADO

is a standard-based program design model that can be used to create distributed applications for data sharing. In ADO, the dataset occupies an important position, which is a copy of some of the data in the database in memory. Unlike a recordset in ADO, a dataset can include any data table, and each data table can be used to represent data from a database table or view. The dataset resides in memory and is not connected to the original database, i.e. it does not have to remain connected to the original database. The underlying technique for completing the work is XML, which is the storage and transport format used by the dataset. During run time, the data in the dataset needs to be exchanged between components, such as a business logic object or an ASP. The data is transferred from one component to another in the form of an XML file, and the receiving component restores the file to the DataSet form. The method of the dataset is exactly the same as the relational data model

Because the protocols for each data source are different, we need to access the data source through the correct protocol. Some older data sources with the ODBC protocol, followed by some data sources with OLE DB protocol, now, there are still many new data sources in the constantly appearing, ADO. NET provides a common method of accessing a data source, and it takes a different class library for different data sources. These class libraries are called Data Providers, and are typically named after the type of data source and the protocol.

Common ways to access your database