Working With MySQL to 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

img 1.gif


Choose a data source in the configuration wizard.

img 2.gif

Choose a Database Model in the following step.

img 3.gif

Then choose the Data connection.

img 4.gif

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

img 5.gif

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

img 6.gif

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

img 8.gif

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

img 9.gif

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: