• 简介
  • 插入数据
  • 更新数据
    基本更新 复杂更新
  • 删除数据
  • 查询数据
    基本查询 联表查询 分页查询 子查询 联合查询 聚合查询
  • 常用函数

简单更新,返回成功/失败


new DBHelper<DTStudentModel>()
.Update()
.Where(p => p.IdentityID == p.IdentityID);
.Execute(new DTStudentModel()
{
    IdentityID = 1,
    StuCode = "01",
    StuName = "张三",
    StuAge = DateTime.Parse("2012-10-02"),
    StuSex = "男"
});
-- 对应 SQL
update T_Student set StuCode=@StuCode,StuName=@StuName,StuAge=@StuAge,StuSex=@StuSex where ([T_Student].[IdentityID] = @IdentityID)
    

简单更新,返回影响行数


new DBHelper<DTStudentModel>()
.Update()
.Where(p => p.IdentityID == p.IdentityID);
.AffectedRows(new DTStudentModel()
{
    IdentityID = 1,
    StuCode = "01",
    StuName = "张三",
    StuAge = DateTime.Parse("2012-10-02"),
    StuSex = "男"
});
-- 对应 SQL
update T_Student set StuCode=@StuCode,StuName=@StuName,StuAge=@StuAge,StuSex=@StuSex where ([T_Student].[IdentityID] = @IdentityID)
    

简单更新,排除某些字段


new DBHelper<DTStudentModel>()
.Exclude(p => new { p.StuCode, p.StuAge })
.Update()
.Execute(new DTStudentModel()
{
    IdentityID = 1,
    StuName = "张三",
    StuSex = "男"
});
-- 对应 SQL
update T_Student set StuName=@StuName,StuSex=@StuSex where ([T_Student].[IdentityID] = @IdentityID)