Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between connected environment and a
disconnected environment?
- 2 Answers
- 7596 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
Why do we use sqldataadapter?
Can you explain how to enable and disable connection pooling?
Explain the two fundamental objects in ado.net?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
What is the usage of the dataset object in ado.net?
What is a column variable?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
Define connection string?
What is openquery?
Which namespaces are used for data access?
Which database is the ado.net sql connection object designed for?
What are all features of ADO.Net?
how Sequence to connect and retrieve data from database using dataset?
What are the various methods provided by the DataSet object to generate XML?
What does datareader object do?
