Challenge: Executing MySQL Commands

Your task is to:

• Create a MySqlCommand object using the commandText command and the connection object;
• Execute the command using the appropriate method;
• Close the connection after executing the command;
• Enclose the code into a try-catch block to make it safer.

Note

The unit tests related to MySQL tasks will only pass if the application connects to an actual database, so for this task, you need to have the MySQL database installed on your device. You can modify the connection string to your local database details for testing purposes. Alternatively, you can compare your code with the given solution code.