What is the difference between connected environment and a
disconnected environment?

Answer Posted / neha

Connected:
In connected environment, the connection object is
constantly opened to operate on the databases, and is closed
after all the operation are performed.
Advantages: fast retrieval of data, updated information is
always accessed
Disadvantage: security threats

Disconnected:
In the disconnected environment, the connection object is
opened for the minimum amount of time, that is, the time
when data is retrieved. After the data is retrieved from the
database, the connection is closed, and all the operations
like INSERT, UPDATE, DELETE, etc are performed offline. The
change during the operation can be reflected back to the
database in the similar manner.
Advantage: no security threats, increase in performance as
connection is not constantly opened.
Disadvantage: slow data retrival.

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you connect to database using .NET?

825


What is ado and rdo?

710


Explain the overview of ado.net architecture?

728


Define atomicity?

811


How do you update a dataset in ado.net?

786


What are the advantages of oledb compared with other classes?

2591


What are the uses of Stored Procedure?

799


What is a control toolbox?

726


What is ole2 format?

695


What is a datareader object?

851


What is ado.net code?

734


What is the use of Dataview?

823


How do you merge 2 datasets into the third dataset in a simple manner?

796


Why do we serialize data?

722


What are the data providers used in ado.net

755