Working With MySQL to Visual Studio 2010

Here we present the connectivity to MySQL from Visual Studio 2010.

Create .NET applications using C#/Visual Basic with connecting to 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 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

Choose a data source in the configuration wizard.

Choose a Database Model in the following step.

Then choose the Data connection.

We have to look different Data connection choose one of them.

After choose the connection add the connection and test the connection.

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

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

Click next and choose the database tables.

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:

• Configuring Visual Studio to work with MY SQL Database
  
  
• Microsoft Visual Studio Professional 2010
  
  
• Working with Union in MySQL
  
  
• Working with Keys in MySQL