public User.Default Select(User.Default user) { using (var conn = new SqlConnection(ConnectionString)) { return(conn.QuerySingle <User.Default>("SELECT * FROM TB_USER WHERE ID=@Id", user)); } }
public int Delete(User.Default user) { using (var conn = new SqlConnection(ConnectionString)) { return(conn.Execute("DELETE FROM TB_USER WHERE ID=@Id", user)); } }
public int Insert(User.Default user) { using (var conn = new SqlConnection(ConnectionString)) { return(conn.Execute(@"INSERT INTO TB_USER(ID, USER_NAME, USER_AGE, CREATE_DT, UPDATE_DT ) VALUES (@Id, @UserName, @UserAge, @CreateDt, @UpdateDt )", user)); } }
public int InsertCustomMapping(User.Default user) { using (var conn = new SqlConnection(ConnectionString)) { return(conn.Execute(@"INSERT INTO TB_USER(ID, USER_NAME, USER_AGE, CREATE_DT, UPDATE_DT ) VALUES (@Id, @Name, @Age, @CDate, @UDate )" , new { Id = user.Id, Name = user.UserName, Age = user.UserAge, CDate = user.CreateDt, UDate = user.UpdateDt })); } }
private void TestDeleteOne() { User.Default user = new User.Default() { Id = "TestUserId1" }; int countDeleteOne = userDao.Delete(user); Console.WriteLine($"Return countDeleteOne : {countDeleteOne}"); }
public int Update(User.Default user) { using (var conn = new SqlConnection(ConnectionString)) { return(conn.Execute(@"UPDATE TB_USER SET USER_NAME = @UserName, USER_AGE = @UserAge, UPDATE_DT = @UpdateDt WHERE ID = @Id ", user)); } }
private void TestSelect() { User.Default user = new User.Default() { Id = "TestUserId1" }; User.Default selectedUser = userDao.Select(user); Console.WriteLine($"selectedUser, id={selectedUser.Id}, name={selectedUser.UserName}, age={selectedUser.UserAge}"); List <User.Default> selectedUserList = userDao.Select(); Console.WriteLine($"selectedUserList, count={selectedUserList.Count}"); }
private void TestUpdate() { User.Default user = new User.Default() { Id = "TestUserId1", UserName = "******", UserAge = 40, UpdateDt = DateTime.Now }; int countUpdate1 = userDao.Update(user); Console.WriteLine($"Return countUpdate1 : {countUpdate1}"); }
private void TestInsert() { User.Default user1 = new User.Default() { Id = "TestUserId1", UserName = "******", UserAge = 30, CreateDt = DateTime.Now, UpdateDt = DateTime.Now }; int countInsert1 = userDao.Insert(user1); Console.WriteLine($"Return countInsert1 : {countInsert1}"); User.Default user2 = new User.Default() { Id = "TestUserId2", UserName = "******", UserAge = 30, CreateDt = DateTime.Now, UpdateDt = DateTime.Now }; int countInsert2 = userDao.InsertCustomMapping(user2); Console.WriteLine($"Return countInsert2 : {countInsert2}"); User.Default user3 = new User.Default() { Id = "TestUserId3", UserName = "******", UserAge = 24, CreateDt = DateTime.Now, UpdateDt = DateTime.Now }; int countInsert3 = userDao.InsertCustomMapping(user3); Console.WriteLine($"Return countInsert3 : {countInsert3}"); }