ADO.NET

From Wikipedia, the free encyclopedia
Jump to: navigation, search
ADO.NET
Operating system Microsoft Windows
Type Software framework
License MS-EULA, BCL under Microsoft Reference License
Website ADO.NET Overview on MSDN

ADO.NET is a set of computer software components that programmers can use to access data and data services based on disconnected DataSets and XML. 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.

Architecture[edit]

Main article: ADO.NET data provider
This technology forms a part of .NET Framework 3.0 (having been part of the framework since version 1.0)

ADO.NET is conceptually divided into consumers and data providers. The consumers are the applications that need access to the data, and the providers are the software components that implement the interface and thereby provide the data to the consumer.

ADO.NET and Visual Studio[edit]

Functionality exists in Visual Studio IDE to create specialized subclasses of the DataSet classes for a particular database schema, allowing convenient access to each field through strongly typed properties. This helps catch more programming errors at compile-time and enhances the IDE's Intellisense feature.

ADO.NET and O/R Mapping[edit]

LINQ to SQL[edit]

Main article: LINQ to SQL

See also[edit]

External links[edit]

ADO.NET
Incubation Projects