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

Is This Answer Correct ?    24 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is faster ado.net or linq?

739


Is bulk insert faster than insert?

678


Explain the difference between an ado.net dataset and an ado recordset?

756


What are dataproviders?

718


Which is faster entity framework or ado.net?

682


Explain the two fundamental objects in ado.net?

666


Define Execute Reader?

817


What is data reader in ado.net?

688


What is sql command in ado net?

690


What are the various methods provided by the DataSet object to generate XML?

799


What is the difference between linq and ado.net?

710


Compare Data Reader & Dataset in ado.net?

733


How do you update a dataset in ado.net?

747


How do you update database through dataset?

716


Is it possible to load multiple tables in a Dataset?

736