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
Explain how do you connect to sql server database without using sqlclient?
How to pass multiple tables in datasets simultaneously?
Define ado.net?
What is the use of ADO.NET and XML web services?
What are the ado.net components?
List all the steps in order, to access a database through ado.net?
What is ambient transaction?
What are the ado.net objects?
Explain advantages of ado.net?
What is difference between sqldatareader and sqldataadapter?
What are all the classes that are available in System.Data Namespace?
What is sqldatareader?
What is a non query?
How we can provide data to ado.net?
What is ado full form?