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
How would you connect to database using .NET?
What is ado and rdo?
Explain the overview of ado.net architecture?
Define atomicity?
How do you update a dataset in ado.net?
What are the advantages of oledb compared with other classes?
What are the uses of Stored Procedure?
What is a control toolbox?
What is ole2 format?
What is a datareader object?
What is ado.net code?
What is the use of Dataview?
How do you merge 2 datasets into the third dataset in a simple manner?
Why do we serialize data?
What are the data providers used in ado.net