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}");
}
