What is main five diffrent between Connected And
Disconnected environment

Answers were Sorted based on User's Feedback



What is main five diffrent between Connected And Disconnected environment..

Answer / sanjip yadav

connection:data is current and update.
connection may,sometime,lead to network
it does not allow to multiple application to simultaneously interact with the data source.
its not improve the Scalability and performance OF application
we can directly use

its allow to multiple application to simultaneously interact with the data source.
its not improve the Scalability and performance OF application
we can not directly use
multiple user are updating to data to data source
data is not always up to data as no connection is establist wid the data source

Is This Answer Correct ?    5 Yes 0 No

What is main five diffrent between Connected And Disconnected environment..

Answer / 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

What is main five diffrent between Connected And Disconnected environment..

Answer / kanchan yangandual

In Simple Words the meaning of connected and disconnected Architecture is 

Connected architecture:
Which have to be live 

Disconnected architecture:
Which do not have to be on live 

Is This Answer Correct ?    1 Yes 0 No

What is main five diffrent between Connected And Disconnected environment..

Answer / banshi

5 Big differences b/w Con/Disconnected Architecture are :
1. Connected Architecture Require a Existing Server whenever
it needs to operate whereas Disconnected requires only a
single time, while fetching data.
2.DataSets,Datatable and Relationships can be maintain
during runtime whereas in Connected Architecture it can't.
3.Connected architecture is faster if there is a toy
operation whereas Disconnected can be perform thousands of
operation without contacting server.
4.Disconnected architecture gives better speed than
connected(If there is More requesting Clients)
5.Datareader is Faster but in Compare Hundred operation it
will surely slow. whereas disconnected gives faster in this case

Is This Answer Correct ?    2 Yes 4 No

What is main five diffrent between Connected And Disconnected environment..

Answer / sandyni

Dataset is disconnected method where Datareader treated as
connected method.

Connected methods gives faster performance where as
disconnected get low in speed and performence.

connected can hold the data of single table, where as
disconnected can hold multiple tables of data.

Disconnected are the forward only and readonly objects
where as connected or not.

Is This Answer Correct ?    113 Yes 135 No

Post New Answer

More ADO.NET Interview Questions

What is difference between executequery and executeupdate?

0 Answers  


FetCh Records No 5 to 10 From Dataset

4 Answers  


What is ado.net explain with diagram?

0 Answers  


Explain how do you connect to sql server database without using sqlclient?

0 Answers  


Explain the two fundamental objects in ado.net?

0 Answers  






How do you connect to sql server database without using sqlclient?

0 Answers  


What are the different row versions available?

3 Answers  


What is ado.net connection?

0 Answers  


What are the major difference between classic ADO and ADO.NET?

0 Answers  


Why sql Data Reader object not created

9 Answers   Matrix,


How to check if a datareader is closed or opened?

1 Answers  


What is connection string?

0 Answers  


Categories