Working With MySQL to Visual Studio 2010

Create .NET applications using C#/Visual Basic with connecting to the MYSql database.

MYSql connector is responsible for creating necessary ADO.Net interfaces and integrations to ADO.Net tools.

Requirements

Visual Studio 2010.
MySQL database – We have to install the MYSql community server, which is the freely available version of the MySQL server.
MySQL admin tools – These tools enable you to work with MySQL through a GUI.
MySQL Connector - Install MySQL connector for .NET, which is basically a .Net library to support MySQL.

First, build Database applications.

img 1.gif

Choose a data source in the configuration wizard.

datasource

Choose a Database Model in the following step.

databasemodel

Then choose the Data connection.

dataconnection

We have to look at different Data connections and choose one of them.

img 5.gif

After choosing the connection, add the connection and test the connection.

img 6.gif

After the test connection succeeded, show my connection name, which we have to connect to it.

connectionsucceeded

Click the next and save the connection string to the application.

connectionstring

Click next and choose the database tables.

img 10.gif

Those are the steps to connect a MySQL database to our .Net application. After creating the connection, we can use it to display, store and manipulate data in our application.

Resources

Here are some useful related resources.