DEV Community

Sardar Mudassar Ali Khan
Sardar Mudassar Ali Khan

Posted on

Introduction To Ado.NET


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.

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

  • 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.


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.

Top comments (0)