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 difference between datareader and dataadapter?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
Does executenonquery return a value?
Explain executenonquery?
Explain the basic use of "dataview" and explain its methods.
What is a control toolbox?
What is serialization and de-serialization in .net?
What are typed and untyped dataset?
What is a non query?
Why do we need ado.net?
What is data view and variable view?
What is microsoft ado?
What is a data control clerk?
Command objects uses, purposes and their methods.
What does ole stand for in excel?