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
Explain ado.net features? Benefits? Drawbacks?
Which method in OLEDBAdapter is used to populate dataset with records?
What are the steps to connect to a database?
What are the different row versions available in table?
Give few examples of datareader that is used in different dataproviders.
What is a dataview?
What is shadow copy?
What is the difference between ado.net and oledb?
Define Execute Scalar?
differance between ADO vs ADO.Net?
Why edit is not possible in repeater?
Which ado.net object is very fast in getting data from the database?
How to retrieve the user id which is provided while windows authentication?
What are the data providers in ADO.NET framework?
What is the provider being used to access oracle database?