What is main five diffrent between Connected And
Disconnected environment

Answer Posted / srikanth

Hi.. Questn is about diff b/w connctd and dis connctd. not
b/w reader and data set..

Connected:-
data provider comes under connected eniv. data
povider contains four components
(Connection,Datareader,Command,DataAdapter).
Dissconnected:-
It contains only DataSet.

Connected:-
In this asynchronous or multiple access can be
doing by using MARS(Multiple Active rsult set)
Discon:-
Is used for async

Connected:-
always there is a direct contact to database
disconnected:-
Not required
Connected:-
Less chance of Diry read
disconnec:-
More
Connected:-
Low Perfomance bcz bulk updation is process taking
disconnected:-
can be done easily and update at a time

Is This Answer Correct ?    26 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the hierarchy of data in databases?

625


Define isolation?

659


Define executenonquery?

622


What is two way data binding android?

628


What is row state?

634






Which is faster dataset or datareader?

655


What is a datagridview?

633


What are the rules to implement connection pooling?

618


How would you connect to a database by using .NET?

615


What is dbcontext and dbset in entity framework?

601


What is ado.net objects?

620


What are the data access namespaces in .NET?

774


What we do with the object of ado.net dataset after using it?

630


What are the features of ado.net?

620


How do I delete a row from a DataTable?

695