Windows中在C#中使用Dapper和Mysql.Data库连接MySQL数据库

git clone https://github.com/ccf19881030/WindowsFormsMySqlDbApp.git

/* Navicat Premium Data Transfer Source Server         : localhost_mysql_root Source Server Type    : MySQL Source Server Version : 80036 Source Host           : localhost:3306 Source Schema         : ytdemo Target Server Type    : MySQL Target Server Version : 80036 File Encoding         : 65001 Date: 09/03/2024 14:34:56*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ------------------------------ Table structure for people-- ----------------------------
DROP TABLE IF EXISTS `people`;
CREATE TABLE `people`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `FirstName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `LastName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `EmailAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;

-- ------------------------------ Records of people-- ----------------------------
INSERT INTO `people` VALUES (1, 'Timothy', 'Corey', '[email protected]');
INSERT INTO `people` VALUES (2, 'Jane', 'Simth', '[email protected]');
INSERT INTO `people` VALUES (3, 'Sue', 'Storm', '[email protected]');
INSERT INTO `people` VALUES (4, 'Bob', 'McClure', '[email protected]');
INSERT INTO `people` VALUES (5, 'Mary', 'Jones', '[email protected]');
INSERT INTO `people` VALUES (6, 'Ray', 'Stone', '[email protected]');
INSERT INTO `people` VALUES (7, '操', '曹', '[email protected]');
INSERT INTO `people` VALUES (8, '权', '孙', '[email protected]');
INSERT INTO `people` VALUES (9, '备', '刘', '[email protected]');
INSERT INTO `people` VALUES (10, '飞', '张', '[email protected]');
INSERT INTO `people` VALUES (11, '羽', '关', '[email protected]');
INSERT INTO `people` VALUES (12, '亮', '诸葛', '[email protected]');