Summary  
Demonstrates how to create and execute a command object for a non-query SQL statement, manage the connection’s lifecycle with a using-statement, and handle errors via try-catch.

General domain of usage  
Database management

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.

This course will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

This module will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

Challenge: Executing MySQL Commands