Pomelo update example

var row_updated = db.Articles
.Where(x => x.Id <= 10)
.Where(x => x.Title == "Hello World")
.Where(x => DateTime.Now >= x.Time)
.SetField(x => x.Title).Prepend("[old] ")
.SetField(x => x.IsPinned).WithValue(true)
.Update();

var row_updated2 = db.Articles
.Where(x => db.Users.Where(y => y.Id %2 == 0).Select(y=>y.Id).Contains(x.Id))
.Delete();