using MySql.Data.MySqlClient; using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Dapper; using System.Text; using Microsoft.Extensions.Configuration; using System.IO; namespace NETCoreMySQL { public class Program { public static void Main(string[] args) { Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); MySqlConnection con = new MySqlConnection("server=127.0.0.1;database=test;uid=root;pwd=;charset='gbk';SslMode=None"); //新增数据 con.Execute("insert into user values(null, '测试', 'http://www.cnblogs.com/linezero/', 18)"); //新增数据返回自增id var id = con.QueryFirst("insert into user values(null, 'linezero', 'http://www.cnblogs.com/linezero/', 18);select last_insert_id();"); //修改数据 con.Execute("update user set UserName = 'linezero123' where Id = @Id", new { Id = id }); //查询数据 var list = con.Query("select * from user"); foreach (var item in list) { Console.WriteLine($"用户名：{item.UserName} 链接：{item.Url}"); } //删除数据 con.Execute("delete from user where Id = @Id", new { Id = id }); Console.WriteLine("删除数据后的结果"); list = con.Query("select * from user"); foreach (var item in list) { Console.WriteLine($"用户名：{item.UserName} 链接：{item.Url}"); } Console.ReadKey(); } } }