Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between connected environment and a
disconnected environment?
- 2 Answers
- 7783 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 does executereader return?
What is ado connection?
What is shadow copy?
What is the maximum pool size in ado.net connection string?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
How can we serialize the dataset object?
What is isolation?
How can we add relation between tables in a dataset?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
What is ado and rdo?
What is ole data type?
What are the major difference between classic ADO and ADO.NET?
What is DataReader Object?
Which database is the ado.net sql connection object designed for?
What is the difference between ADO and ADO.Net?
