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
How to generate a single aggregate?
how we can fire event in databound coulm in datagfrid withot using button?
Explain the various objects in dataset.
Explain the difference between an ado.net dataset and an ado recordset?
How to perform sorting on a table in ADO.NET?
can we create synonymn in ms access,sql server,my sql if so explain me with example
What are the steps you will take to improve performance?
What are the different ado.net namespaces?
What you mean by filtering of data?
Explain sqlconnection object?
How can you add or remove rows from the datatable object of dataset?
What is data adapter in ado.net with example?
What is difference between entity framework and ado.net?
What are the namespaces used in ado.net for data access?
What is ole data type?