ADO.NET Technology: Advantages and Disadvantages
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
This solution summarizes how ADO.NET can help with the given application, and its advantages/disadvantages.
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):
SQLClient:
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 ...
Purchase this Solution
Free BrainMass Quizzes
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Javscript Basics
Quiz on basics of javascript programming language.
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.
Basic Networking Questions
This quiz consists of some basic networking questions.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.