ADO.NET and Access, Microsoft SQL and Oracle
Not what you're looking for?
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?
Purchase this Solution
Solution Summary
ADO.NET technology is investigated for developing an application to access and manage databases created using Access, Microsoft SQL and Oracle. A summary of the investigation is presented to show advantages and potential problems of using this technology in this situation.
Solution Preview
CONTENTS
Evolution Summary of ADO.NET 2
The ADO.NET Data Architecture 3
DataSet 3
Data Provider 4
What advantages can you identify? 4
What potential problems might you encounter? 4
Evolution Summary of ADO.NET
? DAO (data access model), the first data access model, was created for local databases with the built-in Jet engine, which had performance and functionality issues.
? RDO (Remote Data Object) and ADO (Active Data Object), the next data access models, were designed for Client Server architectures.
? However, ADO took over RDO soon. ADO was a good architecture but as the language changes so is the technology.
With ADO, all the data is contained in a recordset object, which had problems when implemented on the network and penetrating firewalls. ADO was a connected data access, which means that when a connection to the database is established the connection remains open until the application is closed. Leaving the connection open for ...
Purchase this Solution
Free BrainMass Quizzes
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Basic Networking Questions
This quiz consists of some basic networking questions.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
C# variables and classes
This quiz contains questions about C# classes and variables.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.