Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between connected environment and a
disconnected environment?
- 2 Answers
- 7702 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 microsoft ado?
What is a data control clerk?
How to pass values into a datatable?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
How do you update a dataset in ado.net and how do you update database through dataset?
Why edit is not possible in repeater?
Define Execute Scalar?
What is ole in vb?
What is the difference between OLEDB Provider and SqlClient?
What is connected architecture in ado.net?
What are the benefits of using ado.net?
What is difference between entity framework and ado.net?
What is the difference between Dataset. clone and Dataset.copy?
What is disconnected architecture in ado.net?
What are the benefits of ADO.NET?
