ADO.NET provides a set of classes for working with data. ADO.NET is a set of classes, interfaces, structures and enumerations that manage data access in the .net framework

ADO.NET object model

ADO.NET object model provides an infrastructure that you can use to access data from different Data Sources.
There are two main component of this object model
Dataset and .Net data provider

Dataset
Datatable		DataTable
Odbc provider	Sqlserver data provider	Oledb.Netprovider	Oracle Dataprovider
Odbc sources	Sqlserver	Oledb sources	Oracle sources

                                     Fig:ADO.NET Object Model

How accesing data with ADO.NET

• Client makes request
• Create a sqldatasource
• Return the data to the client
• Update the data
• Use the SQLdatasource to open a data base connection, update the database and close the connection