Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between connected environment and a
disconnected environment?
- 2 Answers
- 7691 Views
- I also Faced
- E-Mail Answers
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 is a datagridview?
What is the default provider in ado.net?
What is ado.net code?
What you mean by filtering of data?
Does dapper use ado.net?
What providers does Ado.net uses?
Name which operations can you not perform on an ado.net dataset?
What do you know about ADO.NET's objects and methods?
Which method in OLEDBAdapter is used to populate dataset with records?
What is execute reader in ado.net?
What is ado circle?
What are the classes in System.Data.Common Namespace?
What is the difference in an abstract class and an interface?
What is the default Timeout for SqlCommand.CommandTimeout property?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
