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
How to create data relations?
If a table contains 20000 records. In a page at each time 100 records to be displayed.
Explain the architecture of ado.net?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
What DataReader class do in ADO.NET ?
What is the advantage of ado.net?
What is the significance of CommandBehavior.CloseConnection ?
What are basic methods of dataadapter?
What are dcl commands?
How is entity framework different from ado.net?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What is the maximum pool size in ado.net connection string?
What is difference between ado and other data object?
Explain the namespaces in which .net has the data functionality class.
Explain the overview of ado.net architecture?