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

How to find the given query is optimised one or not?

738


What are the advantages of oledb compared with other classes?

2562


Compare Data Reader & Dataset in ado.net?

749


What is data adapter in ado.net with example?

706


Explain the differences between oledb sql server, oledbdotnet provider?

759


Is ado.net dead?

756


What is the difference between SqlCommand and SqlCommandBuilder?

798


What is commandbuilder in ado.net?

729


Explain what are the steps to connect to a database?

733


Why do we need ado.net?

735


What is the role of the dataset object in ado.net?

804


How we can provide data to ado.net?

759


What is DataReader Object?

787


What are datareaders?

696


How to read data with the sqldatareader ?

744