ASP NET Data Access Introduction ADO NET allows

ASP. NET Data Access

Introduction • ADO. NET allows us 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. • The ADO. NET Framework supports two models of Data Access Architecture, Connection Oriented Data Access Architecture and Disconnected Data Access Architecture.

Connection Oriented Data Access Architecture • In Connection Oriented Data Access Architecture the application makes a connection to the Data Source and then interact with it through SQL requests using the same connection. In this case the application stays connected to the database system even when it is not using any Database Operations. • In Connection Oriented Data Access, when we read data from a database by using a Data. Reader object, an open connection must be maintained between our application and the Data Source.

Disconnected Data Access Architecture • The disconnected approach makes no attempt to maintain a connection to the data source. • ADO. Net provides a new solution by introducing a new component called Dataset. The Dataset is the central component in the ADO. NET Disconnected Data Access Architecture. A Dataset is an in-memory data store that can hold multiple tables at the same time. Datasets only hold data and do not interact with a Data Source. • One of the key characteristics of the Dataset is that it has no knowledge of the underlying Data Source that might have been used to populate it. • The ADO. NET Disconnected Data Access Architecture far more flexible and powerful than ADOs Connection Oriented Data Access. • Unlike the Data. Reader, the Data. Set is not connected directly to a Data Source through a Connection object when we populate it. It is the Data. Adapter that manages connections between Data Source and Dataset by filling the data from Data Source to the Dataset and giving a disconnected behavior to the Dataset. The Data. Adapter acts as a bridge between the Connected and Disconnected Objects.

ADO. NET Architecture