vs怎么调用mysql数据库

using MySql.Data.MySqlClient;

string connectionString = "server=<server_address>;port=<port_number>;user=<username>;password=<password>;database=<database_name>";
MySqlConnection connection = new MySqlConnection(connectionString);
connection.Open();

// 在此处执行数据库操作

connection.Close();

string query = "SELECT * FROM table_name";
MySqlCommand command = new MySqlCommand(query, connection);

using (MySqlDataReader reader = command.ExecuteReader())
{
    while (reader.Read())
    {
        // 处理查询结果
    }
}

string query = "INSERT INTO table_name (column1, column2, ...) VALUES (@value1, @value2, ...)";
MySqlCommand command = new MySqlCommand(query, connection);
command.Parameters.AddWithValue("@value1", value1);
command.Parameters.AddWithValue("@value2", value2);
// 添加其他参数

int rowsAffected = command.ExecuteNonQuery();

string query = "UPDATE table_name SET column1 = @value1, column2 = @value2 WHERE condition";
MySqlCommand command = new MySqlCommand(query, connection);
command.Parameters.AddWithValue("@value1", value1);
command.Parameters.AddWithValue("@value2", value2);
// 添加其他参数

int rowsAffected = command.ExecuteNonQuery();

string query = "DELETE FROM table_name WHERE condition";
MySqlCommand command = new MySqlCommand(query, connection);
// 添加条件参数

int rowsAffected = command.ExecuteNonQuery();