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
What is the role of data provider in ado.net?
Why is ADO.NET serialization slower than ADO ?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What are the advantages and disadvantages of using datalist?
What is data control techniques?
What does ado stand for in ado.net?
What is connected architecture in ado.net?
What are the different row versions available in table?
What is fill method in ado.net?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is typed dataset ?
What is the use of Dataview?
Which ado.net object is very fast in getting data from the database?
What is ado.net components?
What is read only and forward only in ado.net?
