Follow in Twitter & Facebook

Like in Facebook

Powered By Blogger Widgets

Free Download

FREE Tools

Thursday, March 15, 2012

Connected and Disconnected Architecture Ado.Net

I am sharing some differences between Connected and Disconnected Architecture in ADO.Net in To communicate with database we must have connection from front end application to database.

They can be of two type.
Connected Architecture:
(1)- In Connected Architecture you have to declare the connection explicitly by using Open() and close the connection by using Close() and you can execute commands using different methods like ExecuteNonQuery(),ExecuteScalar() and ExecuteReader().

(2)- Connected Environment needs constantly connection of user to datasource while performing any operation.

(3)- Only one operation can be performed at a time in connected environment.

(4)- Connected environment is slower in speed.

(5)- We get updated data in connected environment.

Disconnected Architecture:
(1)- In Disconnected Architecture, you don't need to define the connection explicitly.Sql DataAdopter itself can open and close the connection and you can use dataset for storing the information temporarily and Fill() is used to execute the commands give in adopter.

(2)- Disconnected environment doesn't need any connection.

(3)- Multiple operations can be performed at a time in disconnected environment.

(4)- It has a good speed.

(5)- In disconnected environment, there is a problem in dirty read.

Also check What is Connection Pooling in Asp.Net ?

0 on: "Connected and Disconnected Architecture Ado.Net"