C# SQL Connection not found

Question

How can I connect a SQL database in C#?

My code:

const string connectionString = "Data Source=127.0.0.1;User ID=root;Database=MyDatabase;Password=MyPassword";
var conn = new SqlConnection(connectionString);
conn.Open();
conn.Close();

I get: Error: 40 - could not open a connection to sql server. I tried also in Python and it worked well:

cnx = mysql.connector.connect(user='root', password='MyPassword', host='127.0.0.1', database='MyDatabase')
cursor = cnx.cursor()

What am I missing in C#?

Answer 1

Please use MySqlConnection for MySql DB.

            const string connectionString = "Data Source=127.0.0.1;User ID=root;Database=MyDatabase;Password=MyPassword";         
            MySqlConnection conn = new MySqlConnection(connectionString );
            conn.Open();

            string sqlcommand = "SELECT Query";
            MySqlCommand cmd = new MySqlCommand(sqlcommand , conn);