Answer Posted / vaidyanathan r.
ADO.NET provides 2 types of architecture.
1. Connection Oriented
2. Connectionless
Connection Oriented architecture is achieved by the use of
Connection, Command and DataReader. Connection management
should done by the user. This architecture is used for
viewing data for continuous monitoring of data.
Connectionless architecture is achieved by the use of
Connection, Command and DataAdapter. The data is retrieved
from the database and stored in the dataset(local
representation of a part or full of actual database). The
connection management is handled by the DataAdapter. The
connection is created when the query or DML operation is
run against the database and cut immediately after the
operation is over. This architecture is mainly used for
doing Modifications in the data.
| Is This Answer Correct ? | 32 Yes | 8 No |
Post New Answer View All Answers
Can we load multiple tables in a dataset?
Explain how to find the given query is optimised one or not?
What is difference between dataset and datatable?
How can we add/remove row's in "datatable" object of "dataset"?
What is isolation?
What is data control techniques?
What are the parameters that control most of connection pooling behaviours?
What is defaultview in datatable?
Why edit is not possible in repeater?
What is data reader in ado.net?
What are the advantages of ado.net?
What Is Difference Between Ado And Ado.net?
What is ado control?
What are the major challenges in accessing data from a database?
What is sqldatareader?
