ADO.NET is the framework that is integrated within the Microsoft .NET framework that allows programmers the ability to write software applications that interact with data storage models. It is a component based platform for developing distributed, heterogeneous, interoperable applications aimed at manipulating any type of data over any network under any operating system and any programming language.
When using ADO.NET there are two ways it interacts with data. The data is first retrieved from a Data Provider. The Data Provider is the component that connects with a Database Management System to retrieve data. This data is then transformed into a data set. The data set is a disconnected memory resident representation of the data. In other words, it contains the tables, columns, rows, relationships, and constraints in the internal memory and is working with that data on the machine itself and not in a live environment using the DBMS.
Data Provider Objects
In order to use ADO.NET correctly, it must support a specific set of objects to support the ability to manipulate data. These objects include:
- Connection - Defines the data source used, server name, database, ect
- Command - SQL code to be executed within a database connection. Used to interact with data between client and server.
- DataReader - Read Only instance to retrieve data sequencally
- DataAdapter - Used to manage a DataSet Object. Allows modifications to data
- DataSet - In-Memory representation of the data
- DataTable - Representation of the data in a tabular format. Allows for the enforcement of entity integrity.
Support with Visual Studio
Microsoft Visual Studio has the ability to utilize ADO.NET because it is integrated within the IDE of Visual Studio
Supported Database Applications
- Microsoft SQL Server
- Oracle Database
- Microsoft Access
- Database with OLE DB support
Rob, P, & Coronel, C. (2009). Database Systems: Design, Implementation, and Management, Eighth Edition. Boston: Thomson - Course Technology.
Microsoft Corporation. (2009). Overview of ADO.NET. Retrieved from http://msdn.microsoft.com/en-us/library/h43ks021(VS.71).aspx