What is main five diffrent between Connected And
Disconnected environment
Answer Posted / harikumar m
1.
Connected Uses: Data Provider(It Includes
Connection,DataCommand,DataReader)
Disconnected Uses: Data Set,Data Adapter
2.
Connected: Network traffic is high,poor in Performance
DisConnection: Network traffic is low,Good in Performance
3.
Connected: Data is up to date
Disconnected: Data is not up to date
4.
Connected: 'Join' can be used to relate two tables
Disconnected: DataRelations(a Class) can be used to relate
two tables
5.
Connected: Forward only, and Read Only
Disconnected: Scollable
6.
Connected:Handle single table at a time
Disconnected: Handle multiple table at a time
7.
Connected: Not persisted
Disconnected: Persisted
| Is This Answer Correct ? | 29 Yes | 3 No |
Post New Answer View All Answers
Some important instruction regarding ADO.NET connection string ?
What is Data view?
What is the default provider in ado.net?
What is row state?
What is the purpose of using adodb?
What is executequery?
Define isolation?
Explain how to create dynamic gridview?
How can we serialize the dataset object?
What is different between sqlcommand object and command behavior object?
Define data access layer?
What is the difference between DataReader and DataSet in ADO.NET?
What is the difference in record set and dataset?
How do you find the count of records in a dataset?
What is Dataset Object?