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

What is the maximum pool size in ado.net connection string?

652


Which database is the ado.net?

669


What is ole data type?

663


Is it possible to load multiple tables in a Dataset?

700


What is the use of SqlCommandBuilder?

805






How to creating a SqlCommand Object?

751


What is aggregate root?

662


Which is faster datareader or dataadapter?

696


Explian About DataAdapters

740


What are the pre-requisites for connection pooling?

685


Why is ADO.NET serialization slower than ADO ?

748


What is typed dataset ?

838


What is the difference between typed and untyped dataset?

656


How many major types of connection objects in ADO.NET?

754


What are the advantages and disadvantages of using datalist?

668