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
What is an ADO.Net?
If we are not returning any records from the database, which method is to be used?
What are the advantages of oledb compared with other classes?
Define connection string?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What is a column variable?
Explain ODP.net
What is linq and entity framework?
Why is ADO.NET serialization slower than ADO ?
What are the steps you will take to improve performance? Will you use dataset or datareader?
Which database is the ado.net?
How can you add or remove rows from the datatable object of dataset?
Which method in OLEDBAdapter is used to populate dataset with records?
What are dataproviders?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?