ADO.NET Tutorial

ADO.NET(ActiveX Data Objects .NET) is a modern Microsoft technology that permits us to access a relational database from an application's code.

ADO.NET is a set of classes that expose data access services for .NET Framework programmers. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational, XML, and application data. ADO.NET supports a variety of development needs, including the creation of front-end database clients and middle-tier business objects used by applications, tools, languages, or Internet browsers.

ADO.NET uses some ADO objects, such as the Connection and Command objects, and also introduces new objects. Key new ADO.NET objects include the DataSet, DataReader, and DataAdapter.

ADO.NET Objects are :

  • Connections. For connection to and managing transactions against a database.
  • Commands. For issuing SQL commands against a database.
  • DataReaders. For reading a forward-only stream of data records from a SQL Server data source.
  • DataSets. For storing, remoting and programming against flat data, XML data and relational data.
  • DataAdapters. For pushing data into a DataSet, and reconciling data against a database.

ADO.NET Tutorial Topics