Summary  
This chapter demonstrates how to establish a MySQL database connection in C#, define and execute a CREATE TABLE command as a non-query using ExecuteNonQuery, and manage the connection lifecycle with a using statement.

General domain of usage  
Inventory management

A grocery store's business is expanding, and they need an efficient way to keep track of their products. They hire you to make an application for them, which is based on a MySQL database where they can store and monitor all the products that they have in stock.

Your task is to write the C# code for:

1. Connecting to your local MySQL database;
2. Creating a new table called `products` with the following columns:
- **id:** A column of type integer;
- **name:** A string value up to 100 characters;
- **category:** A string representing the category of the product. Can be up to 100 characters;
- **price:** A float value representing the price;
- **stock_quantity:** An integer representing the quantity of the product available in stock.

You can either create and connect to a new database or use an existing one.

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: Using CREATE