Cómo crear una conexión MySQL local en C#

 --
 --Structure of the `contact` table
 --


CREATE TABLE IF NOT EXISTS `contact` (
  `id` int(10) NOT NULL,
  `name` varchar(250) NOT NULL,
  `tel` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Copy

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;


// MySQL library added in references.


using MySql.Data.MySqlClient;


namespace MySQLConCCharp
{
}
Copy

// 127.0.01 is the localhost address of the Apache XAMPP server
// We created a database named "Customers"
// The default user when installing XAMPP is "root" without a password.
string connectionString = "SERVER=127.0.0.1; DATABASE=Customers; UID=root; PASSWORD=";
Copy

public class Contact
{
// Creation of 3 properties identifier, name and telephone
public int Id { get; set; }
public string Name { get; set; }
public string Tel { get; set; }


// Constructor
public Contact()
{
}
}
Copy

public class DBContacts
{


    private MySqlConnection connection;


    // Constructor
    public DBContacts()
    {
        this.InitConnexion();
    }


    // Method to initialize the connection
    private void InitConnexion()
    {
        //Creating the connection string
        string connectionString = "SERVER=127.0.0.1; DATABASE=Customers; UID=root; PASSWORD=";
        this.connection = new MySqlConnection(connectionString);
    }


    // Method to add a contact
    public void AddContact(Contact contact)
    {
        try
        {
            // Open SQL connection
            this.connection.Open();


            // Creation of an SQL command based on the connection object
            MySqlCommand cmd = this.connection.CreateCommand();


            // SQL request
            cmd.CommandText = "INSERT INTO contact (id, name, tel) VALUES (@id, @name, @tel)";


            // use of the contact object passed as a parameter
            cmd.Parameters.AddWithValue("@id", contact.Id);
            cmd.Parameters.AddWithValue("@name", contact.Name);
            cmd.Parameters.AddWithValue("@tel", contact.Tel);


            // Executing the SQL command
            cmd.ExecuteNonQuery();


            // Closing the connection
            this.connection.Close();
        }
        catch
        {
        // Error management :
        // Possibility of creating a Logger for SQL exceptions received
        // Possibility of creating a method with a boolean in return to know if the contact was added correctly.
        }
    }
}
Copy

static class Program
{


    static void Main(string[] args)
    {
        // Create a contact to add
        Contact contact = new Contact();
        contact.Id = 1;
        contact.Name = "John";
        contact.Tel = "2567407000";


        // Creation of the DBContacts object for interaction with the MySQL database
        DBContacts dbContacts = new DBContacts();
        dbContacts.AddContact(contact);
    }
}
Copy