Google News
logo
ADO.NET - Interview Questions
What is ADO.NET?
* ADO.NET stands for Active Data Object, it is a part of the .NET Framework by Microsoft. ADO.NET framework provides a set of classes that are used to handle data communication with data sources such as XML files and databases (such as SQL, Oracle, MySQL, MS Access, etc.).

* ADO.NET can separate mechanisms for data connectivity, data access, and data manipulation.

* It has introduced the disconnected architecture, in which data can be stored in a DataSet. ADO.NET has providers for database connection, commands for execution, and result retrieval.

* The ADO.NET classes are stored in the DLL named System.Data.dll.

* Various applications like ASP.NET applications, console applications, windows applications, etc., will use ADO.NET for database connection, command execution, and retrieval of data.

ADO.NET provides mainly the following two types of architectures :
 
  * Connected Architecture.
  * Disconnected Architecture.
Advertisement