Connected and Disconnected Data Access Architecture

-

Connected and Disconnected Data Access Architecture

The ADO.NET Framework supports two models of Data Access Architecture, Connection Oriented Data Access Architecture and Disconnected 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 these cases the application stays connected to the database system even when it is not using any Database Operations.
ADO.Net solves this problem by introduces 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.
  DataSet ds = new DataSet();
In Connection Oriented Data Access, when you read data from a database by using a DataReader object, an open connection must be maintained between your application and the Data Source. Unlike the DataReader, the DataSet is not connected directly to a Data Source through a Connection object when you populate it. It is the DataAdapter that manages connections between Data Source and Dataset by fill the data from Data Source to the Dataset and giving a disconnected behavior to the Dataset. The DataAdapter acts as a bridge between the Connected and Disconnected Objects.
  SqlDataAdapter adapter = new SqlDataAdapter("sql", "connection");
  DataSet ds = new DataSet();


adapter.Fill(ds, "Src Table");
By keeping connections open for only a minimum period of time, ADO .NET conserves system resources and provides maximum security for databases and also has less impact on system performance.

Comments

Post a Comment

Popular posts from this blog

Querying a Data Table Using Select Method and Lambda Expressions in Dot Net

-
Image
.Net Questions and Ans.. Q. 1 Querying a Data Table Using Select Method and Lambda Expressions in Dot Net Suppose we have a DataTable object having four fields: SSN, NAME, ADDRESS and AGE. We could create a data table and add columns in the following way: DataTable  dt =  new   DataTable (); dt.Columns.Add( "SSN" ,  typeof ( string )); dt.Columns.Add( "NAME" ,  typeof ( string )); dt.Columns.Add( "ADDR" ,  typeof ( string )); dt.Columns.Add( "AGE" ,  typeof ( int )); // Showing how to set Primary Key(s) in a Data table (Although it's not compulsory to have one) DataColumn [] keys =  new   DataColumn [1]; keys[0] = dt.Columns[0]; dt.PrimaryKey = keys; Now we store some data in our data table "dt" to show how we can perform several queries on the DataTable object like filtering some data, finding a person's record...
Read more

StringToTable

-
ALTER FUNCTION [dbo].[udf_StringToTable] (       @list NVARCHAR(MAX) ,       @delimiter NCHAR(1) = ',' --Defaults to CSV ) RETURNS @tableList TABLE ( value nvarchar(MAX) ) AS BEGIN     DECLARE @value NVARCHAR(MAX)     DECLARE @position INT     SET @list = LTRIM(RTRIM(@list))+ ','     SET @position = CHARINDEX(@delimiter, @list, 1)     IF REPLACE(@list, @delimiter, '') <> ''     BEGIN         WHILE @position > 0         BEGIN             SET @value = LTRIM(RTRIM(LEFT(@list, @position - 1)))             IF @value <> ''             BEGIN                 INSERT INTO @tableList (value)   ...
Read more

GetPhoneSSNFormat

-
ALTER FUNCTION [dbo].[udf_GetPhoneSSNFormat] (     -- Add the parameters for the function here     @TypeId        INT,     @DataValue    NVARCHAR(MAX) ) RETURNS NVARCHAR(MAX) AS BEGIN     DECLARE @FormattedValue    NVARCHAR(MAX)     SET @FormattedValue = ''     -- Will Remove all white spaces, brackets, hyphens     DECLARE @OriginalValue    NVARCHAR(MAX)     SET @OriginalValue = ISNULL(REPLACE(REPLACE(REPLACE(REPLACE(@DataValue,'(',''),')',''),'-',''),' ',''),'')         -- Type Id : 1 For Phone #     -- Type Id : 2 For SSN #     IF @TypeId = 1         BEGIN             SELECT @FormattedValue =              ...
Read more