//删除
public bool DeleteEntityById(int id, string connectionString = null)
{
using (IDbConnection conn = DapperDataBaseConfig.GetSqlConnection(connectionString))
{
string deleteSql = @"DELETE FROM Student WHERE Id=@Id";
return(conn.Execute(deleteSql, new { id = id }) > 0);
}
}
//获取所有
// public IEnumerable<Student> RetriveAllEntiry(string connectionString = null)
// {
// using (IDbConnection conn = DapperDataBaseConfig.GetSqlConnection(connectionString))
// {
// string querySql = @"SELECT * FROM Student";
// return conn.Query<Student>(querySql);
// }
// }
//根据主键Id获取一个用户
public Student RetriveOndeEntiry(int id, string connectionString = null)
{
using (IDbConnection conn = DapperDataBaseConfig.GetSqlConnection(connectionString))
{
string querySql = @"SELECT * FROM Student WHERE Id=@Id";
return(conn.QueryFirstOrDefault <Student>(querySql, new { id = id }));
}
}
//修改
public bool UpdateEntity(Student entity, string connectionString = null)
{
using (IDbConnection conn = DapperDataBaseConfig.GetSqlConnection(connectionString))
{
string updateSql = @"UPDATE Student
SET [UserName] = @UserName
,[Password] = @Password
,[Gender] = @Gender
,[Birthday] = @Birthday
,[UpdateUserId] = @UpdateUserId
,[UpdateDate] = @UpdateDate
,[IsDeleted] = @IsDeleted
WHERE Id = @Id";
return(conn.Execute(updateSql, entity) > 0);
}
}
//新增
public bool CreateEntity(Student entity, string connectionString = null)
{
using (IDbConnection conn = DapperDataBaseConfig.GetSqlConnection(connectionString))
{
// new Student{FirstMidName="Nino",LastName="Olivetto",EnrollmentDate=DateTime.Parse("2005-09-01")}
string insertSql = @"
INSERT INTO Student
(
FirstMidName
,LastName
,EnrollmentDate
)
VALUES
(
@FirstMidName
,@LastName
,@EnrollmentDate
)
";
return(conn.Execute(insertSql, entity) > 0);
}
}