What is ADO.NET? and What are the two fundamental objects in ADO.NET?

                                Hi Friends, in this article I will explain about what is ADO.NET? And what are the two fundamental objects in ADO.NET?

What is ADO.NET?

•  The full form of ADO is ActiveX Data Object.
• ADO.NET is very important feature of the .NET Framework.
• ADO.NET is a Microsoft .NET Framework data access technology, which provides communication between relational and non-relational systems through a common set of components.
• ADO.NET is built for the disconnected architecture through Dataset Object, which is completely independent from the Data Source.
• ADO.NET is a set of classes that expose data access services to the .NET programmer.
• It is used to handle the data access. It contains a number of classes that provide you with various methods and attributes to manage the communication between your application and data source.
• ADO.NET is an object-oriented set of libraries that allows you to interact with data sources.
• It is used to access the different data Sources such as Microsoft SQL Server, and XML, as per your requirements.

The following figure shows the ADO.NET architecture.

• In ADO.NET the two key components are Data Providers and Dataset. The .Net Framework includes mainly five Data Providers for ADO.NET.
• SQL data provider, OLEDB and ODBC, Oracle and Borland providers are the main Data Providers in the.Net Framework.

What are the two fundamental objects in ADO.NET?

The two fundamental objects are

1. Datareader: It is the connected architecture.

2. Dataset: It is the disconnected architecture.

Go to another interview question Differences between Stored Procedures and Functions | Stored Procedures vs Functions (Difference between SP & UDF)