ADO.NET
ADO.NET is an object-oriented set of libraries that allows you to interact with data sources. Commonly, the data source is a database, but it could also be a text file, an Excel spreadsheet, or an XML file. For the purposes of this tutorial, we will look at ADO.NET as a way to interact with a data base.
there are many different types of databases available.
For example, there is Microsoft SQL Server, Microsoft Access, Oracle, Borland Interbase,
and IBM DB2, just to name a few.
It
is a part of the base class library that is included with the Microsoft
.NET Framework. It is commonly used by programmers to access and modify
data stored in relational database systems, though it can also access
data in non-relational sources.
Data Providers
ADO.NET provides a relatively common way to interact with data sources, but comes
in different sets of libraries for each way you can talk to a data source. These
libraries are called Data Providers and are usually named for the protocol or data
source type they allow you to interact with. See the table below.
| Provider Name | API prefix | Data Source Description | |
|---|---|---|---|
| ODBC Data Provider | Odbc | Data Sources with an ODBC interface. Normally older data bases. | |
| OleDb Data Provider | OleDb | Data Sources that expose an OleDb interface, i.e. Access or Excel. | |
| Oracle Data Provider | Oracle | For Oracle Databases. | |
| SQL Data Provider | Sql | For interacting with Microsoft SQL Server. | |
| Borland Data Provider | Bdp | Generic access to many databases such as Interbase, SQL Server, IBM DB2, and Oracle. |
No comments:
Post a Comment