Jasper22.NET: Install MySQL and Generate POCO Classes

Posted by jasper22 at 09:58 | Thursday, August 11, 2011

Install MySQL 5.5

    Install MySQL 5.5 by executing “mysql-5.5.11-win32.msi”.
        After successful installation, we need to create the user who can access MySQL.
        Steps to create USER:
            Open MySQL Command Line Client:

Install Connector

Connector/Net is a fully-managed ADO.NET driver for MySQL.

Install connector using “mysql-connector-net-6.3.6.msi”.
Generate POCO
Adding an Entity Data Model

You will now add an Entity Data Model to your solution.

In the Solution Explorer, right-click your application and select Add, New Item.... From Visual Studio installed templates, select ADO.NET Entity Data Model. Click Add.