ADO.NET Overview

ADO.NET overview

ADO.NET is design to provide data access. ADO.NET supports disconnected database access model which means that connection is open long enough to perform data operation and is closed. When data is requested by the application, connection is opened, required data is loaded to the application and connection gets close. So in ADO.NET, connection is only available when it is required. This model reduces system resource usage and thus enhances performance.

ADO.NET is shipped with the Microsoft .NET Framework. It is used to access relational data sources, XML, and application data.
ADO.NET uses XML for data transaction between client application and database.

To access data using ADO.NET's DataAdapter objects create connection using connection object.

- Create Dataset object using DataAdapter object.
- Load data into Dataset using fill method of DataAdapter.
- Display Data using Dataset object.
- Close connection
ADO.NET vs ADO
ADO.NET vs ADO - ADO.NET is considered as evolution version of ADO....
ADO.NET Data Architecture
ADO.NET Data Architecture - ADO.NET has four layers - The Physical Data Store: This can be any database, XML files or OLE....
Type of database connection in ADO.NET
ADO.NET - Type of database connection in ADO.NET - SQL Connection: This object connects to the SQL Server.....
Post your comment