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 are the advantages of oledb compared with other classes?
What is the usage of the dataset object in ado.net?
What are the data providers used in ado.net
What are the data providers in ADO.NET framework?
Explain the differences between oledb sql server, oledbdotnet provider?
What are the advantages of ado.net?
Which is faster entity framework or ado.net?
What is difference between ado.net and asp net?
What are two important objects of ADO.Net?
What is execute scalar in ado.net?
How does entity framework work?
What is dataset and datatable in ado.net?
What does ole stand for in excel?
What is the difference between data reader and data adapter?
How to create dynamic gridview?