What is main five diffrent between Connected And
Disconnected environment

Answer Posted / neha

1.Connected: It works when connection object is opened.
Disconnected: It works regardless of the connection object
state (opened or closed doesnot matter).

2.Connected: It can retrieve data from single table only.
Disconnected: It can retrive data from multiple tables.

3.Connected: The data persists even after the shutdown of
application.
Disconnected: The data doesnot persist after the application
closure, as it was all programmatic.

4.Connected: We get the updated data always.
Disconnected: The data we retrieve is not guaranteed to be
updated.

5.Connected: Fast access to the data.
Disconnected: Slow access to data.

6.Connected: It is useful in the scenarios where data is
updated rapidly, for eg, stock market.
Disconnected: It is useful in the scenarios where data is
not updated usually, for eg, school database, where data is
changed after one year only.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define different execute methods of ADO.NET command object ?

627


Which is faster entity framework or ado.net?

578


What are the usages of the command object in ado.net?

640


What is ole db query?

626


What is ole db and odbc?

586






What is the difference in an abstract class and an interface?

590


What is difference between Dataview and Datatable?

619


Explain all the classes those are used for database connections between sql server and asp.net?

604


Explain how to pass multiple tables in datasets simultaneously?

595


Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

525


What providers does Ado.net uses?

659


What is connection pooling and what is the maximum pool size in ado.net connection string?

594


Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

713


What is serialization and de-serialization in .net?

566


What is data reader in ado.net?

580