The lessons on this site assume that you know Managed
C++ and MS Visual C++ .NET but you don't need to know SQL or ADO.NET.
To create the applications in our lessons, we will use Microsoft Visual C++
To create graphical applications of these lessons, you will
need the .NET Framework. You can download it free from the http://www.asp.net
web site. In most cases, it may already be installed in your computer.
Otherwise, after downloading, you can following setup to install it.
TO develop graphical MySQL applications, you must install MySQL, which you can freely download from the http://www.mysql.com
web site. After downloading it, you should install it.
After installing MySQL, if you want to create .NET
applications, you should install the MySQL Connector/Net driver that you can
also download from the MySQL web site. Like that of MySQL, the installation of
the MySQL Connector/Net is particularly easy.
ADO.NET is a group of libraries used to create powerful
databases using various sources that include Microsoft SQL Server, Microsoft
Access, Oracle, XML, etc. ADO.NET relies on the .NET Framework's various classes
to process requests and perform the transition between a database system and the
user. The operations are typically handled through the DataSet class. While
ADO.NET is the concept of creating and managing database systems, the DataSet
class serves as an intermediary between the database
engine and the user interface, namely the Windows controls that the user uses to
interact with the computer. Still, a DataSet object is used to manage
lists, any lists, not just those created using database engines.
Using the MySQL Connector/Net
To support the .NET Framework applications, MySQL provides a
series of classes in the MySQL Connector/Net. To use these classes, you should
(must) reference the MySql.Data.dll library. The classes used by the
MySQL database engine are defined in
the MySql::Data namespace.