Brief about ADO.Net Components

Thursday, July 30, 2009

ADO.Net Components
• ADO.Net is a disconnected data access framework in .net which allows to access database very efficiently and scalable.
• In ADO.Net data is represented by DataSet which is in disconnected form. (In- memory representation).
•In ADO.Net architecture consist of main four components.
- Connection (connection object is used for connecting the database)
- Command (command object is used execute SQL command or stored procedure in the database)
- Data Reader (data reader command is used for forward only, read only data access from the database)
- Data Adapter (data adapter command is used for interaction between database and dataset. It is used to fill the dataset and update the database through the dataset)
• Visual Studio .Net provides two data provides.
- SQL data provider
- OleDb data provider