Question

Which of the following illustrates the benefit of ADO.NET?
1. Interoperability
2. It uses DataSet to represent data in memory that can store data from multiple tables and multiple sources.
3. Connected data access
4. Both (1) and (2)

Answer 1

Correct Answer - Option 4 : Both (1) and (2)

The Correct Answer is "Both (1) and (2)".

• Key Benefits Of ADO.NET
  • Interoperability
  • Scalability
  • Productivity
  • Performance

• Interoperability :
  • The ability to communicate across heterogeneous environments.
  • ADO.NET addresses the common data-exchange limitation by using XML as its payload data format.
  • Since XML is text-based and simple to parse, it’s a good choice for a common, platform-independent, and transportable data format.
  • Furthermore, because XML is nothing more than structured text, employing XML as the data format on top of the HTTP network protocol minimizes firewall-related problems.
  • With ADO and its XML format, the clients do not have to know COM to de-serialize the packaged data.
• Scalability :
  • The ability to serve a growing number of clients without degrading system performance.
  • ADO.NET moves away from the client/server model by promoting the use of disconnected datasets.
  • When a client requests some data, the data is retrieved, it’s transferred to the client, and—as soon as possible—the connection is torn down.
  • Since the connection between the client and the data source is short-lived, this technique allows more clients to request information from the server, thus solving the problem of limited connections.
• Productivity :
  • The ability to quickly develop robust data access applications using ADO.NET’s rich and extensible component object model.
  • ADO.NET’s rich data access classes allow developers to boost their productivity.
  • Current ADO developers should have no problems getting up to speed with the object model because ADO.NET is a natural evolution of ADO.
  • The core functionality remains the same. With ADO.NET, the functionality is factored and distributed to each object in the model—much better than in previous versions of ADO.
• Performance :
  • An improvement over previous ADO versions due to the disconnected data model.
  • Because ADO.NET is mainly about disconnected datasets, the system benefits from improved performance and scalability.
  • The database server is no longer a bottleneck when the number of connection requests goes up.
  • Data Providers in ADO.NET also enable implicit connection pooling, which reduces the time required to open a connection.