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.