| abstract
| - 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. 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. Microsoft Visual Studio has the ability to utilize ADO.NET because it is integrated within the IDE of Visual Studio
* Microsoft SQL Server
* Oracle Database
* MySQL
* Microsoft Access
* Database with OLE DB support Sources 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
- ADO.NET is a set of computer software components that programmers can use to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework. It is commonly used by programmers to access and modify data stored in relational database systems, though it can also access data in non-relational sources. ADO.NET is sometimes considered an evolution of ActiveX Data Objects (ADO) technology, but was changed so extensively that it can be considered an entirely new product.
|