ADO.NET With MySQL

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++ .NET.

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.

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.