public void BaseDelete()
{
var data = new StudentDto
{
Score = 50.5,
StuGender = true,
CreateTime = DateTime.Now,
Version = Guid.NewGuid().ToString("N"),
StuName = "zs",
};
var id = _context.From <StudentDto>().InsertReturnId(data);
_context.From <StudentDto>().Delete(a => a.Id == id);
var flag = _context.From <StudentDto>().Exists(a => a.Id == id);
Assert.False(flag);
}
public void ExecuteSql()
{
var data = new StudentDto
{
Score = 50.5,
StuGender = true,
CreateTime = DateTime.Now,
Version = Guid.NewGuid().ToString("N"),
StuName = "zs",
};
var sql = @"INSERT INTO student
(stu_name,stu_gender,score,version,create_time) values
(@StuName,@StuGender,@Score,@Version,@CreateTime)";
var row = _context.Execute(sql, data);
Assert.Equal(1, row);
}
public void ExpressionUpdate()
{
var data = new StudentDto
{
Score = 50.5,
StuGender = true,
CreateTime = DateTime.Now,
Version = Guid.NewGuid().ToString("N"),
StuName = "zs",
};
var id = _context.From <StudentDto>().InsertReturnId(data);
var row = _context.From <StudentDto>()
.Set(a => a.Score, a => a.Score + 0.5)
.Where(a => a.Id == id)
.Update();
var entity = _context.From <StudentDto>().Where(a => a.Id == id).Single();
Assert.Equal(entity.Score, data.Score + 0.5);
}
public void BaseUpdate()
{
var data = new StudentDto
{
Score = 50.5,
StuGender = true,
CreateTime = DateTime.Now,
Version = Guid.NewGuid().ToString("N"),
StuName = "zs",
};
_context.From <StudentDto>().Insert(data);
var entity = _context.From <StudentDto>().Where(a => a.Version == data.Version).Single();
entity.Score = 1;
entity.StuName = "BaseUpdate";
entity.StuGender = false;
var row = _context.From <StudentDto>().Update(entity);
Assert.Equal(1, row);
}