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
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
What is ole in excel?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
What is an ADO.Net?
What is dataset object? Explain the various objects in dataset.
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....
What is data reader in ado.net?
What is difference between executenonquery and executequery?
How to check if the Dataset has records ?
What is the role of data provider in ado.net?
What is a non query?
Does ado.net use odbc?
What is Data Provider?
What is the return type of executescalar?
