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

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

652


What is the use of data grid?

704


What are the advantages of using datalist?

709


Explain the difference between sqlcommand object and command behavior object?

754


What is ado.net object model?

716


What is the difference between OLEDB Provider and SqlClient?

726


What are the main differences between classic ado and ado.net?

749


Give an example that shows how to execute a stored procedure in ado.net?

801


What is data relation?

689


What is the use of connection object in ado.net?

781


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

774


What is the difference between DataReader and DataSet in ADO.NET?

826


Explain ado.net features?

783


Explain the difference between ado and ado.net?

700


Can we do database operations without using any of the ado.net objects?

765