Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between connected environment and a
disconnected environment?
- 2 Answers
- 7579 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 need ado.net?
How to pass values into a datatable?
Explain the namespaces in which .net has the data functionality class.
Explian About DataAdapters
How do you update a dataset in ado.net?
Which is faster datareader or dataadapter?
What are the advantages of oledb compared with other classes?
What are the ado.net connection pooling parameters?
How can we add relation between tables in a dataset?
Explain the difference in record set and dataset?
Explain sqlconnection object?
What are the several execute methods of ado.net?
What is ado.net and its architecture?
What are the 3 major types of connection objects in ado.net?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
