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
Define different execute methods of ADO.NET command object ?
Which is faster entity framework or ado.net?
What are the usages of the command object in ado.net?
What is ole db query?
What is ole db and odbc?
What is the difference in an abstract class and an interface?
What is difference between Dataview and Datatable?
Explain all the classes those are used for database connections between sql server and asp.net?
Explain how to pass multiple tables in datasets simultaneously?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
What providers does Ado.net uses?
What is connection pooling and what is the maximum pool size in ado.net connection string?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
What is serialization and de-serialization in .net?
What is data reader in ado.net?