using MySqlConnector;

string host = "localhost";
string name = "zoldzrt";
string user = "zoldzrt";
string pass = "titok";

string connstr = $"Server={host};Database={name};User ID={user};Password={pass};";
using MySqlConnection conn = new(connstr);
try {
    conn.Open();
    string sql = "delete from employee where id=@id";
    using MySqlCommand cmd = new MySqlCommand(sql, conn);
    cmd.Parameters.AddWithValue("id", 4);
    int rowsAffected = cmd.ExecuteNonQuery();
    Console.WriteLine($"Érintett sorok száma: {rowsAffected}");
}catch(MySqlException e) {
    Console.Error.WriteLine("Hiba! A törlés sikeretelen!");
    Console.Error.WriteLine(e.Message);
}