What are the different ADO.NET namespaces are available in .NET.
The following namespaces are available in .NET.
This namespace is the base of ADO.NET. It provides all the classes that are used by data providers. The most import class that it supports is DataSet. It also contains classes to represent tables, columns, rows, relation and the constraint class.
This namespace defines common classes that are used as base classes for data providers. These classes are used by all data providers. Examples are DbConnection and DbDataAdapter
This namespace provides classes that work with OLE-DB data sources using the .NET OleDb data provider.Example of these classes are as follows:
It defines the data provider for the SQL Server database. It contains classes such as
This namespace provides classes for specific data types for the SQL Server database.
What is an ADO.Net?
ADO.Net is commonly termed as ActiveX Data Objects which is a part of .Net Framework. ADO.Net framework has set of classes which are used to handle data access by connecting with different databases like SQL, Access, Oracle, etc…
What is the full form of ADO?
The full form of ADO is ActiveX Data Object.
Differentiate between Boxing and Unboxing
The process of storing a value type into a reference type variable or object is known as boxing. Unboxing is the opposite of boxing and is referred to as the process of storing a reference type into a value type variable. In .NET, boxing is done implicitly, while a casting mechanism is required to achieve unboxing.
Define the data provider classes that is supported by ADO.NET.
The .NET framework data provider includes the following components for data manipulation:
Connection: Used for connectivity to the data source
Command: This executes the SQL statements needed to retrieve data, modify data or execute stored procedures. It works with connection object.
DataReader: This class is used to retrieve data. DataReader is forward only and read-only object. We cannot modify the data using DataReader.
DataAdapter: It works as bridge between dataset and data source. Datadapter uses fill method to load the dataset.