1. Download Connector/Net a fully-managed ADO.NET driver for MySQL (mysql-connector-net-6.8.3.msi or later version) from: http://dev.mysql.com/downloads/connector/net/ and install the connector
2. In Solution Explorer right click on References and select "Add Reference..."
3. In Reference Manager windows Search Assemblies for: mysql
4. Select MySql.Data and click Ok, you can see "MySql.Data" in References
5. Use the code below:
using System;
using MySql.Data.MySqlClient;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
string sql_con = "Server=localhost;Database=database_name;Uid=user_name;Pwd=password";
using (var connection = new MySqlConnection(sql_con))
using (var command = connection.CreateCommand())
{
connection.Open();
command.CommandText = "select * from table_name";
using (var reader = command.ExecuteReader())
while (reader.Read())
{
Console.WriteLine(reader.GetString(0) + "\n\n");
}
}
}
}
}
