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
Is ado.net dead?
How would you connect to a database by using .NET?
Give few examples of datareader that is used in different dataproviders.
Define executenonquery?
What is an orm, and why would you use one instead of plain old ado.net?
Explain ado.net features? Benefits? Drawbacks?
Can you explain how to enable and disable connection pooling?
What are the important features of ado.net 2.0?
Explain all the classes those are used for database connections between sql server and asp.net?
What connected data?
What do you mean by ‘batch updates’?
What is the difference between executenonquery () and executescalar ()?
What is row state?
Which parameter of ConnectionString is used to specify the name of the database?
How to copy the contents from one table to another table and how to delete the source table in ado.net?