What is main five diffrent between Connected And
Disconnected environment
Answer Posted / pratik
connected data needs connection to be created to access
hence slower while disconnected is in memory data thats
faster access.
to access connected data you use ADO.NET whereas for
disconnected you do not use.
disconnected-data can be accessed from multiple tables in a
dataset.
connected- .net runtime creats an instance of the datatable
to hold data.
in disconnected data you can create a window to the
datatable in the form of a dataview used to sort and filter
data..which cannot be done in connected data access
connected you need to use a read only forward only data
reader,disconnected you cannot.
disconnected data in a dataset can be serialized/deserialized.
| Is This Answer Correct ? | 114 Yes | 35 No |
Post New Answer View All Answers
How to generate a single aggregate?
What are the objects of ado.net?
What is ado oledb and odbc?
What is the difference between dataset and datatable?
What does executenonquery () method return?
How to creating a SqlCommand Object?
Can you explain how to enable and disable connection pooling?
What are the essential features of ado.net?
What is ole2 format?
What are the Features of a dataset
What is ado.net architecture?
What are the parameters that control most of connection pooling behaviours?
What is row state?
Which method is used to sort the data in ADO.Net?
What is difference between datatable and dataset?