ADO.NET is the new version of Microsoft’s Ado (ActiveX data objects) object model for data access.


[ hide ]

  • 1 General
  • 2 Main Components
    • 1 .NET Framework Data Providers
    • 2 The DataSet
  • 3 New Features
    • 1 Managed providers
    • 2 Disconnected classes
  • 4 Sources


ADO.NET is the latest technology databases from Microsoft that represents an efficient way to manipulate data. It is a set of classes that expose data access services from the Microsoft .net platform. It was designed to work with disconnected data sets, reducing network traffic. It uses XML as the universal data transmission format and meets a variety of development needs including: creating client database applications for users and mid-tier business objects using Internet applications, tools, languages, or browsers . ADO .NET has a series of objects that are the same as those that appeared in the previous version of ADO, such as the Connection or Command object, also introduces new objects such as the DataReader , DataSet or DataView object .

Main components

There are two components of ADO.NET that can be used to access and manipulate data:

.NET Framework data providers

The .NET Framework data providers are components specifically designed for data manipulation and fast access to read-only and forward-only data. The Connection object provides connectivity to a data source. The Command object allows access to database commands to return data, modify data, execute stored procedures, and send or retrieve information about parameters. The DataReader objectProvides a high-performance data stream from the data source. Finally, the DataAdapter object provides the bridge between the DataSet object and the data source. The DataAdapter uses Command objects to execute SQL commands on the data source both to load the DataSet with data and to reconcile changes applied to the data included in the DataSet to the data source.

The DataSet

The ADO.NET DataSet is expressly designed for data access regardless of the data source. As a result, it can be used with multiple and different data sources, with XML data, or to manage local application data. The DataSet contains a collection of one or more DataTable objects consisting of rows and columns of data, as well as information about primary keys, foreign keys, constraints, and relationships relative to the data included in the DataTable objects.

New Features

Managed providers

Server Enumeration: Provides support for enumeration of active Microsoft SQL Server instances .

Asynchronous Processing: Allows you to perform asynchronous database operations using an API modeled after the asynchronous model using the .NET Framework . Bulk Copy Operations: Enables quick bulk inserts using the .NET Data Provider for SQL Server.

SQL Server Notifications: Allows the .NET Framework applications to send a command to SQL Server and request that a notification be generated if executing the same command would produce different result sets than the ones initially retrieved.

Disconnected classes

DataSet enhancements: The new DataTableReader presents the contents of a DataSet or DataTable formatted in one or more read-only and forward-only result sets.

DataSet binary serialization: The new option allows the serialization of a DataSet and a DataTable in binary format when using binary transports through the remote service. In most cases, the result is a huge performance improvement and a significant reduction in memory and CPU usage when DataSet / DataTable objects are used in applications that use the remote service to connect at different levels.

Full namespace tables: A DataSet can now support tables that have the same table name but different namespace, thanks to a mechanism that prevents name conflict.


Leave a Comment