Explore BrainMass


Your boss met with you this morning to inform you that the system you wrote 2 years ago using dBase IV now needs to be rewritten using Visual Basic.NET and ADO.NET.

Before proceeding, you have been asked to learn more about ADO.NET and provide a summary of what you discover.

What is ADO.NET?

What benefits might it offer in this rewrite?

What potential disadvantages are there?

Solution Preview

What is ADO.NET?
From MSDN [1]:
"ADO.NET is a set of classes that expose data access services to the .NET programmer. ADO.NET provides functionality to developers writing managed code similar to the functionality provided to native COM developers by ADO. ADO.NET provides consistent access to data sources such as Microsoft® SQL Server?, as well as data sources exposed through OLE DB and XML. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and update data.

ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data. ADO.NET supports a variety of development needs, including the creation of front-end database clients and middle-tier business objects used by applications, tools, languages, or Internet browsers."

"ADO.NET separates data access from data manipulation into discrete components that can be used ...