Download and install the .net - mysql-connector from:
http://dev.mysql.com/downloads/connector/net/1.0.html
(You'll be asked to register but you don't need to, just browse down on the webpage)

Tutorial-like documentation to some of the connector classes
http://dev.mysql.com/doc/refman/5.1/en/connector-net-using-prepared.html  (highly recommended to use!)
http://dev.mysql.com/doc/refman/5.1/en/connector-net-examples-mysqldatareader.html


Some basic code:


// connect to server. "protocol=pipe" works only for local machine.
MySqlConnection myConnection = new MySqlConnection(
	"server=localhost; user id=root; password=; database=movie;protocol=pipe");
myConnection.Open();
            
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = "SHOW TABLES;";
cmd.Prepare(); // read first tutorial to see why this is required and what it can be used for ;-)

MySqlDataReader myReader = cmd.ExecuteReader();

while (myReader.Read())
{
	Console.WriteLine(myReader.GetString(0));
}
myReader.Close(); // don't forget!
myConnection.Close(); // don't forget!