简单更新,返回成功/失败
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)