ADO.Net Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 2210 Page Views: 

What are the advantages of ADO.Net?



Posted By: Avi Date: 6 October 2009 05:17:57 AM
 Answer:

ADO.Net offers following benefits:

1) XML is the format for transmitting datasets across the network, so any component that can read the XML format can process data.

2) ADO.NET provides a very rich API which helps help developers to develop programs more quickly and with fewer mistakes.

3) ADO.Net offers performance advantages over ADO due to its disconnected architecture and connection pooling.

4) ADO.NET accommodates scalability by encouraging programmers to conserve limited resources. Because any ADO.NET application employs disconnected access to data, it does not retain database locks or active database connections for long durations.


Posted By: eTechPlanet


Date: 6 October 2009 05:17:57 AM

ADO.NET applications can take advantage of the flexibility and broad acceptance of XML. Because XML is the format for transmitting datasets across the network, any component that can read the XML format can process data. In fact, the receiving component need not be an ADO.NET component at all: The transmitting component can simply transmit the dataset to its destination without regard to how the receiving component is implemented. The destination component might be a Visual Studio application or any other application implemented with any tool whatsoever.


Posted By: Daniel


Date: 16 February 2010 03:43:00 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image XW3JHZ
Related Questions
ADO.Net : How can we force the Connection object to close after DataReader object is closed?

How can we force the Connection object to close after DataReader object is closed?

We use ExecuteReader method of Command object to get the DataReader object. This ExecuteReader metho....
Category: ADO.Net Date: 10/6/2009 6:34:42 AM
ADO.Net : How to make decision about using DataSet over DataReader?

How to make decision about using DataSet over DataReader?

Use a DataSet when you need to do following: 1) Navigate between multiple discrete tables of resul....
Category: ADO.Net Date: 10/6/2009 5:56:34 AM
ADO.Net : What is the difference between DataSet and DataReader?

What is the difference between DataSet and DataReader?

Following are some major differences between DataSet and DataReader: 1) DataReader provides forward....
Category: ADO.Net Date: 10/6/2009 5:47:03 AM
ADO.Net : What is a DataReader object?

What is a DataReader object?

DataReader object provides a read-only, forward-only stream of data from a database. The DataReader ....
Category: ADO.Net Date: 10/6/2009 5:35:46 AM
ADO.Net : What are the advantages of ADO.Net?

What are the advantages of ADO.Net?

ADO.Net offers following benefits: 1) XML is the format for transmitting datasets across the networ....
Category: ADO.Net Date: 10/6/2009 5:17:57 AM