ServiceStack.OrmLite 筆記5 改

修改

db.Update(new Person { Id = 1, FirstName = "Jimi", LastName = "Hendrix", Age = 27});

// sql:UPDATE "Person" SET "FirstName" = 'Jimi',"LastName" = 'Hendrix',"Age" = 27 WHERE "Id" = 1

db.Update(new Person { Id = 1, FirstName = "JJ" }, p => p.LastName == "Hendrix");

// UPDATE "Person" SET "Id" = 1,"FirstName" = 'JJ',"LastName" = NULL,"Age" = NULL WHERE ("LastName" = 'Hendrix')

//部分更新

db.Update

(new { FirstName = "JJ" }, p => p.LastName == "Hendrix");

db.UpdateNonDefaults(new Person { FirstName = "JJ" }, p => p.LastName == "Hendrix");

//UPDATE "Person" SET "FirstName" = 'JJ' WHERE ("LastName" = 'Hendrix')

db.UpdateOnly(new Person { FirstName = "JJ" }, p => p.FirstName);

//UPDATE "Person" SET "FirstName" = 'JJ'

db.UpdateOnly(new Person { FirstName = "JJ", Age = 12 },

onlyFields: p => new { p.FirstName, p.Age });

//UPDATE "Person" SET "FirstName" = 'JJ', "Age" = 12

db.UpdateOnly(new Person { FirstName = "JJ" },

onlyFields: p => p.FirstName,

where: p => p.LastName == "Hendrix");

db.UpdateOnly(new Person { FirstName = "JJ", LastName = "Hendo" },

onlyFields: q => q.Update(p => p.FirstName));

onlyFields: q => q.Update(p => p.FirstName).Where(x => x.LastName == "Jimi"));

//UPDATE "Person" SET "FirstName" = 'JJ' WHERE ("LastName" = 'Jimi')

(set: "FirstName = {0}".Params("JJ"),

where: "LastName = {0}".Params("Hendrix"));

db.Update(table: "Person", set: "FirstName = {0}".Params("JJ"),

//UPDATE "Person" SET FirstName = 'JJ' WHERE LastName = 'Hendrix'

//先擷取 再更新

var updatedRow = db.SingleById

(rowId);

db.Update(updatedRow);

// save方法，沒有則添加 ，有則修改

Save and SaveAll will Insert if no record with Id exists, otherwise it Updates

作者：

過錯

出處：http://www.cnblogs.com/wang2650/

關于作者：net開發做的久而已。十餘年時光虛度！

本文版權歸作者和部落格園共有，歡迎轉載，但未經作者同意必須保留此段聲明，且在文章頁面明顯位置給出原文連接配接。如有問題，可以郵件：[email protected]

 聯系我，非常感謝。