ADO.NET
ADO.NET is data access technology it is evolution from DAO to RDO to ADO
DAO- Data Access Objects
RDO-Remote Data Object
ADO-ActiveX Data Objects
ADO.NET-Not an acronym
ADO.NET Features
•ADO.NET supports both connected and disconnected solution
•It has tight integration with XML and .Net Framework
•HTTP is used to transport XML between layers
•ADO.NET is managed library of code and has same rules as managed library Connected Layer
•In this our base code will explicitly connected with a data base, the connection is explicitly opened and closed
•It is achieved using Data Reader objects to get records from data store using forward-only, read-only approach
Disconnected Layer
•The disconnected layer is achieved using Dataset. Dataset is local copy of any number of related data tables
•Once the user gets Dataset object it is completely disconnected from the DBMS
•the connection is opened and closed automatically on our behalf
•Data adapter objects are used to fill a Data set with Data Table
•Using Dataset the client tier is able to update and modify its contents of data source while it is disconnected, and it can submit the modified data back using related data adapter
•The main advantage of this layer is data is manipulated without incurring the network traffic
