//CreatesTable with below format
public void CreateTable()
{
string[] CreateMyFields = new string[] { "emp_no", "first_name", "last_name", "birth_date", "gender", "hire_date" };
string[] dataTypes = new string[] { "INT PRIMARY KEY AUTO_INCREMENT NOT NULL", "VARCHAR(255) NOT NULL", "VARCHAR(255) NOT NULL", "DATE NOT NULL", "ENUM('male', 'female', 'other') NOT NULL", "DATE NOT NULL" };
connection.CreateTable(table_name, CreateMyFields, dataTypes);
}