mysql如何和vs联系

using MySql.Data.MySqlClient;
using System;

namespace MySQLConnectionDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Server=your_server_address;Database=your_database_name;Uid=your_username;Pwd=your_password;";
            using (MySqlConnection connection = new MySqlConnection(connectionString))
            {
                try
                {
                    connection.Open();
                    string query = "SELECT * FROM your_table_name";
                    MySqlCommand command = new MySqlCommand(query, connection);
                    using (MySqlDataReader reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            Console.WriteLine(reader[0].ToString());
                        }
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Error: " + ex.Message);
                }
            }
        }
    }
}