Explain ADO.NET Architecture
ADO.NET stands for ActiveX Data Object. It is a database access technology created by Microsoft. It is a part of .NET framework that can access any kind of data source. It’s a set of object-oriented classes that provides a rich set of data components. ADO.NET uses for creating high-performance, reliable, and scalable database applications for client-server applications. It consists of a set of Objects that expose data access services to the .NET environment.
The Ado.Net Architecture provides the following two types of class objects:
1. Connection-based: They are the data provider objects such as – Connection, Command, DataAdapter, and DataReader. They execute SQL statements and connect to a database.
2. Content-based: They are found in the System.Data namespace. It also includes DataSet, DataColumn, DataRow, and DataRelation. They are completely independent of the type of data source.
System.Data: It contains the definition for columns, relations, and tables. It also defines the database, rows, views, and constraints.
System.Data.SqlClient: It contains the classes that are used to connect to an MS-SQL server database. Such as SqlCommand, SqlConnection, and SqlDataAdapter.
System.Data.Odbc: It contains classes required to connect to most ODBC drivers. These classes include OdbcCommand and OdbcConnection.
System.Data.OracleClient: It contains classes such as – OracleConnection and OracleCommand. It requires connecting to an Oracle database.