What is main five diffrent between Connected And
Disconnected environment

Answer Posted / harikumar m

1.
Connected Uses: Data Provider(It Includes
Connection,DataCommand,DataReader)
Disconnected Uses: Data Set,Data Adapter

2.
Connected: Network traffic is high,poor in Performance
DisConnection: Network traffic is low,Good in Performance

3.

Connected: Data is up to date
Disconnected: Data is not up to date

4.
Connected: 'Join' can be used to relate two tables
Disconnected: DataRelations(a Class) can be used to relate
two tables

5.

Connected: Forward only, and Read Only
Disconnected: Scollable

6.

Connected:Handle single table at a time
Disconnected: Handle multiple table at a time

7.

Connected: Not persisted
Disconnected: Persisted

Is This Answer Correct ?    29 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we do database operations without using any of the ado.net objects?

535


Why is ADO.NET serialization slower than ADO ?

569


What is ado object model?

519


What is executenonquery ado.net?

497


Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

558






What is Serialization in .NET? what are the types of Serialization?

555


Why do we serialize data?

497


Explain how to create dynamic gridview?

521


How does ado.net work?

494


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

619


What are dataproviders?

549


Which control of the BindingNavigator returns the current position within the data source?

733


oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

1930


What are dcl commands?

508


What is aggregate root?

494