Programming C#

MySQL

Database

Create Database

CREATE DATABASE EStore;

Create Table

CREATE TABLE Category(
	CategoryId TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	CategoryName VARCHAR(128) NOT NULL
);

Insert Data

INSERT INTO Category (CategoryName) VALUES ('Laptop'), ('Mouse');

Code C#

Add Package from nuget Mysql

dotnet add package MySqlConnector