using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;

namespace DBConnectionTest
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "datasource=localhost;port=3306;username=root;password=ece426spring2017";
            MySqlConnection connection = new MySqlConnection(connectionString);
            MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
            myDataAdapter.SelectCommand = new MySqlCommand("Select * from sakila.actor ;", connection);
            MySqlCommandBuilder cb = new MySqlCommandBuilder(myDataAdapter);
            connection.Open();
            Console.WriteLine("connected");
            connection.Close();


        }
    }
}


//you gotta download sql connector also https://dev.mysql.com/downloads/connector/net/