. NET Foundation Supplements (8) ADO and Database Development Foundation

1.1 ADO. What kinds of data sources are supported by net?

①system.data.sqlclient

This may be. NET programmers are the most common. can be accessed through OLE DB or ODBC, but the components under SqlClient are directly targeted at MSSQL, so ADO is actually doing some optimization work for it.

②system.data.oracleclient

Used with client components (Oracle.DataAccess.dll) for Oracle database products that have to be paired with an Oracle database.

③system.data.oledb

The components under this namespace are primarily for the standard interface of OLE DB, a low-level API to different data sources provided by Microsoft, and it can also connect to other data sources that are not SQL data types. OLE DB is a standard interface that implements the functions of a unified interface for different data sources.

④system.data.odbc

The components under this namespace are for ODBC standard interfaces.

In general, ADO. NET for us to block all the database access levels, provide a unified API to us, so that we do not have to consider the underlying data source is a specific database or another standard interface.

Visually demonstrates the connection between ADO and a possible data source:

. NET Foundation Supplements (8) ADO and Database Development Foundation