What is main five diffrent between Connected And
Disconnected environment

Answer Posted / chowdary

Data Reader:-
Data Reader is a read only and forward only data
You can access one table at a time.
Data reader cant persist the data.
Data Reader is connected architecture.
Data Reader is faster than Data Adapter
Data Reader is faster than dataset operation
Data Set:
Data Set is disconnected architecture.
Data Set is persist the data.
You can access more than one table
Data Set is main for storage tool in ADO.Net

Is This Answer Correct ?    70 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which property is used to check whether a DataReader is closed or opened?

574


What are the different ado.net namespaces?

632


What does ado stand for?

525


What is ado.net and its architecture?

511


What is the difference between SqlCommand and SqlCommandBuilder?

595






What do you know about ado.net's methods?

594


What are the differences between OLEDB and SQLClient Providers?

571


What is execute reader in ado.net?

504


What are dcl commands?

512


Define bubbled event?

519


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

539


Is it possible to load multiple tables in a Dataset?

536


What is the use of connection object in ado.net?

570


Define atomicity?

587


Does dapper use ado.net?

604