What is main five diffrent between Connected And
Disconnected environment

Answer Posted / sandyni

Dataset is disconnected method where Datareader treated as
connected method.

Connected methods gives faster performance where as
disconnected get low in speed and performence.

connected can hold the data of single table, where as
disconnected can hold multiple tables of data.

Disconnected are the forward only and readonly objects
where as connected or not.

Is This Answer Correct ?    113 Yes 135 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is ADO.NET serialization slower than ADO ?

575


How can I retrieve two tables of data at a time by using data reader?

524


Why do we use sqldataadapter?

489


How do you connect to sql server database without using sqlclient?

568


What is ole used for?

506






What are the data providers used in ado.net

550


Define ado.net?

584


What is dataset object? Explain the various objects in dataset.

598


Which object needs to be closed?

1756


What are disadvantages of microsoft-provided data provider classes in ado.net?

512


How do you merge 2 datasets into the third dataset in a simple manner?

543


What is the difference between Optimistic and Pessimistic locking?

555


What are the advantages and drawbacks of using ado.net?

636


What are the benefits of ADO.NET?

615


What is the use of sqldatareader class?

487