ADO.NET (ACTIVE-X DATA OBJECTS WITH .NET TECHNOLOGY)

1. Describe

1.1. ADO.NET is a data access technology from the Microsoft .NET Framework that provides communication between relational and non-relational systems through a common set of components.

1.2. ADO.NET is a set of computer software components that programmers can use to access data and data services from a database.

1.3. It is a part of the base class library that is included with the Microsoft .NET Framework.

2. Functions

2.1. Application or component; processes and calls ADO.NET functions to submit SQL statements and retrieve results.

2.2. DataSet; as in-memory cache of data which functions like a disconnected XML data cache.

2.3. DataReader; which provides a direct, read-only SQL interface to the backend.