Explore BrainMass

Explore BrainMass

    ADO.NET Technology: Advantages and Disadvantages

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Your company currently has several databases and several database management applications to manage the data, including Access, Microsoft SQL, and Oracle. Your supervisor would like you to develop an application to access and manage all these databases through one Visual Basic program using ADO.NET technology. Investigate ADO.NET and present a summary of how this technology can help in this application. What advantages can you identify? What potential problems might you encounter?

    © BrainMass Inc. brainmass.com February 24, 2021, 6:03 pm ad1c9bdddf

    Solution Preview

    ADO.Net is a perfect choice for choosing as a universal database connector. This will enable to connect any kind of databases not limited to access, Microsoft sql server, Oracle, DB2, mySQL and many more to add.

    What advantages can you identify?
    Scalability is the ability of an application (could be windows or web based) to full fill the growing number of request for performing task(s) in a timely manner with out crashing or inconsistence.
    This is the most desirable quality of any system that has to keep up.
    Scalability is very important in data-connected applications as the number users who are sharing data or making changes is frequent and data integrity should be maintained with having conflicts.
    The following ADO.NET objects allow a developer to build a scalable application(s):

    Avoid using Universal Data Link (UDL) files for OleDb connections as these can cause potential performance hits. NET's SQLClient managed data provider does not support this, as prior versions of SQL Server did.

    Disconnected Access to Data (DataSet):
    For all ...

    Solution Summary

    This solution summarizes how ADO.NET can help with the given application, and its advantages/disadvantages.