ADO.NET is a set of computer software components that can be used by programmers 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 be used to access data in non-relational sources. Visit the austin .net developer to learn more about this.

ADO.NET is sometimes considered an evolution of ActiveX Data Objects (ADO) technology, but was changed so extensively that it can be conceived of as an entirely new product.

ADO.NET architecture consists of two primary parts: the Data Provider and the DataSets.

The Data Provider provides access to a data source, such as a Microsoft SQL Server or Oracle database and OLEDB data provider.

Each data source has its own set of provider objects, but they each have a common set of utility classes. This includes, Connection (Provides a connection used to communicate with the data source), Command (Used to perform some action on the data source, such as reading, updating, or deleting relational data), Parameter (Describes a single parameter to a command), DataAdapter (A bridge used to transfer data between a data source and a DataSet object), and DataReader (Used to efficiently process a large list of results one record at a time). Learn more of this with the austin .net developer.

DataSets objects, a group of classes describing a simple in-memory relational database, were the star of the show in the initial release (1.0) of the Microsoft .NET Framework.

A DataSet is populated from a database by a DataAdapter who's Connection and Command properties have been set. However, a DataSet can save its contents to XML, or populate itself from XML, making it exceptionally useful for web services, distributed computing, and occasionally-connected applications. Visit the austin .net developer for more information about this.

Functionality exists in the Visual Studio .NET IDE to create specialized subclasses of the DataSet classes for a particular database schema, allowing convenient access to each field through strongly-typed properties. For a more detailed information about ADO.NET, then visit the austin .net developer for more details.