ASP.NET Data Access

ADO.NET allows you to implement data access in ASP.NET applications. It is a data access technology from Microsoft .Net Framework , which provides communication between relational and non-relational systems through a common set of components and offers a rich suite of data handling and data binding functions for manipulating all types of data.

asp.net-ado.net-architecture

The .Net Framework includes mainly three Data Providers for ADO.NET. The Microsoft SQL Server , OLEDB and ODBC are the main Data Providers in the .Net Framework. The two key components of ADO.NET are Data Providers and DataSet . From the following chapters you can study each ADO.NET components in detail.

ADO.NET Architecture
Advantages of ADO.Net
Disconnected Data Access Architecture
ASP.NET Connection String
First ASP.NET Database Program