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
Which method is used by command class to execute SQL statements that return single value?
What is the difference between ado.net and oledb?
Explain the two fundamental objects in ado.net?
How is entity framework different from ado.net?
Define bubbled event?
How can you add or remove rows from the datatable object of dataset?
What is sqlconnection and sqlcommand?
What is dataadapter in ado.net?
How can I retrieve two tables of data at a time by using data reader?
What are the disadvantages of using datalist?
What is datasource in ado.net?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What is an ado?
What are all the classes that are available in System.Data Namespace?
What is meant by executenonquery?
