Dapper的应用 _应用

登山则情满于山，观海则意溢于海。这篇文章主要讲述Dapper的应用相关的知识，希望能为你提供帮助。
dapper开发效率极快so easy

using Dapper; using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web; namespace WcfServiceTest { /// < summary> /// Dapper案例 /// < /summary> public class StudentDB { //获取web.config里的连接字符串 public static string connectionString = System.Configuration.ConfigurationManager.AppSettings["connectstring"]; /// < summary> /// 查询指定数据 /// < /summary> /// < param name="person"> < /param> /// < returns> < /returns> public static List< Student> Query(string name) { using (IDbConnection connection = new SqlConnection(connectionString)) { string strsql = "select * from Student where 1=1 "; if (!string.IsNullOrEmpty(name)) { strsql += "and Name like ‘%@Name%‘"; } return connection.Query< Student> (strsql, name).ToList(); } }/// < summary> /// 反填 /// < /summary> /// < param name="id"> < /param> /// < returns> < /returns> public static Student QueryById(int id) { using (IDbConnection connection = new SqlConnection(connectionString)) { return connection.Query< Student> ("select * from Student where [email protected]", id).SingleOrDefault(); } }/// < summary> /// 新增 /// < /summary> /// < param name="student"> < /param> /// < returns> < /returns> public static int Insert(Student student) { using (IDbConnection connection = new SqlConnection(connectionString)) { return connection.Execute("insert into Student(Name,Age) values(@Name,@Age)", student); } }public static int Update(Student student) { using (IDbConnection connection = new SqlConnection(connectionString)) { return connection.Execute("update Studentset Name = @Name,Age= @Age where [email protected]", student); } }/// < summary> /// 删除 /// < /summary> /// < param name="student"> < /param> /// < returns> < /returns> public static int Delete(int Id) { using (IDbConnection connection = new SqlConnection(connectionString)) { return connection.Execute("delete from Student where [email protected]", Id); } }/// < summary> /// 批量删除 /// < /summary> /// < param name="students"> < /param> /// < returns> < /returns> public static int Delete(List< Student> students) { using (IDbConnection connection = new SqlConnection(connectionString)) { return connection.Execute("delete from Student where [email protected]", students); } }} }

【Dapper的应用】