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
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
Why do we use sqldataadapter?
What are the connected and disconnected modes in ado.net?
What are the differences between OLEDB and SQLClient Providers?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
Explain the role of data provider in ado.net?
How do you update database through dataset?
What is ado and dao?
Which is faster entity framework or ado.net?
What is the default Timeout for SqlCommand.CommandTimeout property?
Define connection string?
What is connection string?
Do we use stored procedure in ADO.Net?
Why do we need ado.net?
What is ado in agriculture?