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
What is the default provider in ado.net?
Explain the architecture of ado.net?
What is the full form of ado.net?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
What are the advantages of using datalist?
What is sqldatareader?
Which provider is used to connect ms access, oracle, etc…?
What is a control toolbox?
What are the advantages and drawbacks of using ado.net?
How does ado.net work?
What is a sqldataadapter?
What is defaultview in datatable?
How do you implement locking concept for dataset?
Which namespaces are used for data access?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?