Introduction To Ado.NET

Introduction:

You may connect to and operate with data sources such as databases, excel files, access files, XML files, MySQL, SQL, and notepad using the ADO.NET set of classes. You must be aware of the appropriate Data Provider in order to link your application with various databases. In ADO.NET, there are numerous Data Providers that link to various sources. Below is a list of ADO.NET Data Providers.

Data Providers for.NET in Ado.NET

SQL Server

• System.Data.SqlClient With the help of this Data Provider, you can connect to SQL Server databases.
  OLEDB

• System.Data.OleDb To connect to SQL Server, Oracle, and Microsoft Jet, utilize this Data Provider.
  ODBC

• System.Data.Odbc It is used to connect with SQL Server, Oracle, and Microsoft Databases(.mdb).
  Data Provider for Oracle

• System.Data.OracleClient
  EntityClient Provider
  
  • Gives Entity Data Model (EDM) applications access to data. utilizes the system Namespace Data.EntityClient.
  SQL Server Compact 4.0

• Enables Microsoft SQL Server Compact 4.0 to access data. utilizes the system Namespace Data.SqlServerCe.
  Essential Components of .NET Data Providers
  To connect to, access, and retrieve data from the database, 4 Core Components of.Net Data Providers are used. You must commit to memory these four essential ADO.Net elements.

Connection

To connect to the database, utilize this component. The DbConnection base class is used.

• Command
  This part uses the data source to do SQL queries. The DbCommand base class is used.

• DataReader
  The data source is read for the data. It only has read-only and forward-only access to data. DbDataReader serves as the foundation class.

• DataAdapter
  The dataset is called, and the data source is used to resolve updates. The DbDataAdapter base class.