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
What are the benefits of using ado.net?
What are all the different methods under sqlcommand?
What are the parameters that control most of connection pooling behaviours?
What is the advantage of ado.net?
Which is the feature of ado.net?
What is the difference between a datareader and a dataset?
What are the key events of sqlconnection class?
What is difference between entity framework and ado.net?
Explain the different row versions available in table?
Define table relations?
Which object of ado contains datarow datacolumn collection?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
What is connection pooling and what is the maximum pool size in ado.net connection string?
What is fill method in ado.net?