Click here to Skip to main content
Click here to Skip to main content

ADO.NET

, 11 Oct 2013
Rate this:
Please Sign up or sign in to vote.
 ADO.NET stands for ActiveX Data Objects for .NET. It refers to the suite of data access technologies used to manipulate databases. ADO.NET is part

Editorial Note

This articles was originally at wiki.asp.net but has now been given a new home on CodeProject. Editing rights for this article has been set at Bronze or above, so please go in and edit and update this article to keep it fresh and relevant.

 

ADO.NET stands for ActiveX Data Objects for .NET. It refers to the suite of data access technologies used to manipulate databases. ADO.NET is part of the .NET Framework..

ADO.NET provides access to datasources starting from SQL Server / Oracle to XML based data. Developers using ADO.Net framework can write powerful, efficient, yet datasource agnostic code without a lot of effort.

One of the key innovations implemented in the ADO.Net framework is that the data access routines are kept separate from the manner in which the in memory data is represented and concieved. This concept is popularly known as the "Disconnected Data". ADO.Net also provides pwoerful features to interact with XML datasources.

 Some of the key features in ADO.Net can be categorized as follows

(a) Traditional approach to access / update data through execution of commands. This concept was inherited from the ADO, the COM based data access framework.

(b) DataSet and Data Adapters: The concept of accessing data and then manipulating it in memory without the need of a connection to the datasource. DataSet is concieved as an in memory database as it is designed to use and manipulate relational data.

(c) Data Reader: This option is used to perform a fast, lightweight and forward only read of data from the underlying datasource.

(d) Retrieve Scalars: This is a quick option to execute a query or a stored procedure that returns a single value to the caller.

The ADO.NET classes are found in System.Data.dll, and are integrated with the XML classes found in System.Xml.dll.

 

 

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

ASP.NET Community

United States United States
The ASP.NET Wiki was started by Scott Hanselman in February of 2008. The idea is that folks spend a lot of time trolling the blogs, googlinglive-searching for answers to common "How To" questions. There's piles of fantastic community-created and MSFT-created content out there, but if it's not found by a search engine and the right combination of keywords, it's often lost.
 
The ASP.NET Wiki articles moved to CodeProject in October 2013 and will live on, loved, protected and updated by the community.
Group type: Collaborative Group

247 members


Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web04 | 2.8.140814.1 | Last Updated 11 Oct 2013
Article Copyright 2013 by ASP.NET Community
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid