In this tutorial, I will dive into the nitty gritties of MYSQL 5 Application Development using the MYSQL Connector for .NET for Visual Studio.NET 2005 and build a simple Database Application using VC# and MYSQL 5.
This tutorial is a Level 200 session, which means that pre-requisite knowledge of the products is necessary.
System Requirements:
A basic P4 Machine with 512 MB RAM and about 40 GB HDD, a pointing device,
A keyboard and a monitor.
Software Requirements.
Development Software
Windows 2000 and above.

Microsoft Visual Studio.NET 2005 (Professional or Team System).
(Any edition having C# language support).
Database Software
MySQL Server 5.0 RC Download Link
http://dev.mysql.com/downloads/mysql/5.0.html
Graphical User Interface tools to help MySQL Users
MySQL Administrator 1.1
http://dev.mysql.com/downloads/administrator/1.1.html
MySQL Query Browser 1.1

Building our Database.
Create a database called Customer.
create database Customer;
Create a table called Clients
create table Clients
(
ClientID int primary key,
ClientName varchar(50),
ClientEmail nvarchar(70)
);
To create the above database and table, I have chosen to use the new MySQL Query Browser.
In the figure shown below, is the splash screen for the Query Browser.

Download pdf Beginning MYSQL 5.0 with Visual Studio.NET 2005