学习环境
.net core 2.0
依赖组件
Install-Package MySql.Data -Pre
Install-Package Dappe…
.net core 2.0
Install-Package MySql.Data -Pre
Install-Package Dapper
CREATE TABLE `user` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`UserName` varchar(255) DEFAULT NULL,
`Url` varchar(255) DEFAULT NULL,
`Age` int(11) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
public class User
{
public int Id { get; set; }
public string UserName { get; set; }
public string Url { get; set; }
public int Age { get; set; }
}
public Void Test()
{
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
MySqlConnection con = new MySqlConnection("server=127.0.0.1;database=aspdotnettest;uid=root;pwd=root;charset='utf8';SslMode=None");
//新增数据
con.Execute("insert into user values(null, '测试', '//www.zwbing.com/liuyan/', 18)");
//新增数据返回自增id
var id = con.QueryFirst<int>("insert into user values(null, 'bing', 'https://www.zwbing.com/liuyan/', 18);select last_insert_id();");
//修改数据
con.Execute("update user set UserName = 'zhangwenbing' where Id = @Id", new { Id = id });
//查询数据
var list = con.Query<User>("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<User>("select * from user");
foreach (var item in list)
{
Console.WriteLine($"用户名:{item.UserName} 链接:{item.Url}");
}
}
如果这篇文章对你有所帮助,可以通过下边的“打赏”功能进行小额的打赏。
本网站部分内容来源于互联网,如有侵犯版权请来信告知,我们将立即处理。