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
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
What is the use of data grid?
What are the advantages of using datalist?
Explain the difference between sqlcommand object and command behavior object?
What is ado.net object model?
What is the difference between OLEDB Provider and SqlClient?
What are the main differences between classic ado and ado.net?
Give an example that shows how to execute a stored procedure in ado.net?
What is data relation?
What is the use of connection object in ado.net?
How do you merge 2 datasets into the third dataset in a simple manner?
What is the difference between DataReader and DataSet in ADO.NET?
Explain ado.net features?
Explain the difference between ado and ado.net?
Can we do database operations without using any of the ado.net objects?