相关阅读http://stackexchange.github.io/dapper-dot-net/https://github.com/StackExchange/dapper-dot-nethttps://msdn.microsoft.com/zh-cn/magazine/m ...
相关阅读
http://stackexchange.github.io/dapper-dot-net/
https://github.com/StackExchange/dapper-dot-net
https://msdn.microsoft.com/zh-cn/magazine/mt703432.aspx
引用
可以直接通过Nuget下载,需要源码的话可以通过git去下载,上面已经给出链接
private static List<Student> Read() { using (var connect = new SqlConnection(connectionString)) { connect.Open(); var query = connect.Query<Student>("SELECT TOP 1000 [Id],[Name],[Grade] FROM [TESTDB].[dbo].[Student];"); return query.ToList(); } } private static void Add() { using (var connect = new SqlConnection(connectionString)) { connect.Open(); var result = connect.Execute("INSERT INTO [dbo].[Student]([Id],[Name],[Grade])VALUES(@Id,@Name,@Grade);", new[] { new { Id=2,Name="李四",Grade=1}, new { Id=3,Name="王五",Grade=1}, new { Id=4,Name="赵六",Grade=1} }); Console.WriteLine("影响行数{0}", result); } } private static void Update() { using (var connect = new SqlConnection(connectionString)) { connect.Open(); var result = connect.Execute("UPDATE [dbo].[Student] SET [Grade] = @Grade WHERE Id=@Id; ", new { Id = 2, Grade = 2 }); Console.WriteLine("影响行数{0}", result); } } private static void Delete() { using (var connect = new SqlConnection(connectionString)) { connect.Open(); var result = connect.Execute("DELETE FROM [dbo].[Student] WHERE Id =@Id; ", new { Id = 1 }); Console.WriteLine("影响行数{0}", result); } }
原标题:Dapper一个轻量级的ORM库
关键词:
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。