/// <summary> /// 删除 /// </summary> /// <returns>The delete.</returns> public static int Delete() { int result = 0; using (var conn = DapperHelper.MySqlConnection()) { Users user = new Users(); user.ID = 2; string sqlCommandText = @"delete from Users where Id=@Id"; result = conn.Execute(sqlCommandText, user); } return(result); }
/// <summary> /// 新增 /// </summary> /// <returns>The insert.</returns> public static int Insert() { int result = 0; using (var conn = DapperHelper.MySqlConnection()) { Users user = new Users(); user.Name = "Tim"; user.Age = 30; string sqlCommandText = @"Insert into Users(Name,Age) Values(@Name,@Age)"; result = conn.Execute(sqlCommandText, user); } return(result); }
/// <summary> /// 分页 /// </summary> /// <returns>The list.</returns> public static IList <Users> SearchList() { IList <Users> users = new List <Users>(); int pageIndex = 0; int pageSize = 2; using (var conn = DapperHelper.MySqlConnection()) { IDbTransaction trans = conn.BeginTransaction(); //增加事务 string sqlCommandText = string.Format(@"select * from users limit {0},{1}", pageIndex * pageSize, pageSize); users = conn.Query <Users>(sqlCommandText, null, trans).ToList(); trans.Commit(); } return(users); }
/// <summary> /// 查询 /// </summary> /// <returns>The search.</returns> public static Users Search() { Users user = null; using (var conn = DapperHelper.MySqlConnection()) { string sqlCommandText = @"select * from users where ID=@ID"; user = conn.Query <Users>(sqlCommandText, new { ID = 2 }).FirstOrDefault(); //防sql注入的写法 参数化 //var p = new DynamicParameters(); //p.Add("@ID", 2); //user=conn.Query<Users>(sqlCommandText,p).FirstOrDefault(); } return(user); }
/// <summary> /// 修改 /// </summary> /// <returns>The update.</returns> public static int Update() { int result = 0; using (IDbConnection conn = DapperHelper.MySqlConnection()) { Users user = new Users(); user.ID = 2; user.Name = "tim"; user.Age = 31; string sqlCommandText = @"update users set Age=@Age where Id=@ID"; result = conn.Execute(sqlCommandText, user); } return(result); }
/// <summary> /// 批量新增 /// </summary> /// <returns>The insert.</returns> public static int BulkInsert() { int result = 0; using (var conn = DapperHelper.MySqlConnection()) { IList <Users> users = new List <Users>(); users.Add(new Users { Name = "Tim", Age = 30 }); users.Add(new Users { Name = "Tim", Age = 25 }); string sqlCommandText = @"Insert into Users(Name,Age) Values(@Name,@Age)"; result = conn.Execute(sqlCommandText, users); } return(result); }