public void 查询首行()
{
SynNote_ sn = new SynNote_();
sn.Id = 3;
string updatesql = " select * from SynNote where \"Id\" = @Id";
var ef = LockDapperUtilsqlite.New().QueryFirst <SynNote_>(updatesql, sn);
WriteJson(ef);
}
public void 修改()
{
SynNote_ sn = new SynNote_();
sn.Content = "备注333";
sn.IsDel = false;
sn.Name = "棉花多读懂多多多多好多好多好多好多";
sn.NoteDate = DateTime.Now;
sn.UserId = 2;
sn.Id = 3;
string updatesql = "update SynNote set \"Content\" = @Content, \"NoteDate\" = @NoteDate, \"Name\" = @Name, \"UserId\" = @UserId, \"IsDel\" = @IsDel where \"Id\" = @Id";
var ef = LockDapperUtilsqlite.New().Execute(updatesql, sn);
Console.WriteLine(ef);
}
