What is main five diffrent between Connected And
Disconnected environment
Answer Posted / 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 |
Post New Answer View All Answers
How many major types of connection objects in ADO.NET?
Explain the difference between data reader and data set?
What is data control techniques?
Is bulk insert faster than insert?
What are the steps you will take to improve performance? Will you use dataset or datareader?
Explain the overview of ado.net architecture?
What is sql connection in ado.net?
Is it possible to load multiple tables in a Dataset?
What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What are the ado.net connection pooling parameters?
What is disconnected data?
Which is better ole db or odbc?
What are two important objects of ADO.Net?
Do we use stored procedure in ADO.Net?
How do you update a dataset in ado.net and how do you update database through dataset?