Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain the difference between sqlcommand object and command behavior object?
What Is Difference Between Ado And Ado.net?
What are the pre-requisites for connection pooling?
What are dataproviders?
What we do with the object of ado.net dataset after using it?
What is data reader in ado.net?
Which ado.net object is very fast in getting data from the database?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
Does executenonquery return a value?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
How to add a check box or a dropdown list to a column in a datagrid?
What is the advantage of ado.net?
What is XML serialization
What is the difference between Datareader and Dataset?
Can we connect two dataadapters to same data source using single connection at same time?
