public void Init() { Console.WriteLine("启动Ado.Update"); using (var db = SugarDao.GetInstance()) { //指定列更新 db.Update <School>(new { name = "蓝翔14" }, it => it.id == 14); //只更新name列 db.Update <School, int>(new { name = "蓝翔11 23 12", areaId = 2 }, 11, 23, 12); db.Update <School, string>(new { name = "蓝翔2" }, new string[] { "11", "21" }); db.Update <School>(new { name = "蓝翔2" }, it => it.id == 100); var array = new int[] { 1, 2, 3 }; db.Update <School>(new { name = "蓝翔2" }, it => array.Contains(it.id));// id in 1,2,3 //支持字典更新,适合动态权限 var dic = new Dictionary <string, string>(); dic.Add("name", "第十三条"); dic.Add("areaId", "1"); db.Update <School, int>(dic, 13); //整个实体更新 db.Update(new School { id = 16, name = "蓝翔16", AreaId = 1 }); db.Update <School>(new School { id = 12, name = "蓝翔12", AreaId = 2 }, it => it.id == 18); db.Update <School>(new School() { id = 11, name = "青鸟11" }); //设置不更新列 db.DisableUpdateColumns = new string[] { "CreateTime" };//设置CreateTime不更新 TestUpdateColumns updObj = new TestUpdateColumns() { VGUID = Guid.Parse("542b5a27-6984-47c7-a8ee-359e483c8470"), Name = "xx", Name2 = "xx2", IdentityField = 0, CreateTime = null }; //CreateTime将不会被更新 db.Update(updObj); //以前实现这种更新需要用指定列的方式实现,现在就简单多了。 //批量更新 数据量小时建议使用 var updateResult = db.UpdateRange(GetUpdateList()); //批量更新 数据量大时建议使用 var updateResult2 = db.SqlBulkReplace(GetUpdateList2()); } }
protected void Page_Load(object sender, EventArgs e) { int id = 11; using (var db = SugarDao.GetInstance()) { //指定列更新 db.Update <School>(new { name = "蓝翔14" }, it => it.id == 14); db.Update <School, int>(new { name = "蓝翔11 23 12", areaId = 2 }, 11, 23, 12); db.Update <School, string>(new { name = "蓝翔2" }, new string[] { "11", "21" }); db.Update <School>(new { name = "蓝翔2" }, it => it.id == id); //支持字段指定列更新,适合动态权限 var dic = new Dictionary <string, string>(); dic.Add("name", "第十三条"); dic.Add("areaId", "1"); db.Update <School, int>(dic, 13); db.Update <School>(dic, it => it.id == 13); //整个实体更新 db.Update(new School { id = 16, name = "蓝翔16", AreaId = 1 }); db.Update <School>(new School { id = id, name = "蓝翔18", AreaId = 2 }, it => it.id == 18); db.Update <School>(new School() { id = 11, name = "xx" }); //设置不更新列 db.DisableUpdateColumns = new string[] { "CreateTime" };//设置CreateTime不更新 TestUpdateColumns updObj = new TestUpdateColumns() { VGUID = Guid.Parse("542b5a27-6984-47c7-a8ee-359e483c8470"), Name = "xx", Name2 = "xx2", IdentityField = 0, CreateTime = null }; //CreateTime将不会被更新 db.Update(updObj); //以前实现这种更新需要用指定列的方式实现,现在就简单多了。 } }
protected void Page_Load(object sender, EventArgs e) { int id = 11; using (var db = SugarDao.GetInstance()) { //指定列更新 db.Update <School>(new { name = "蓝翔2" }, it => it.id == id); db.Update <School, int>(new { name = "蓝翔2" }, 11, 23, 12); db.Update <School, string>(new { name = "蓝翔2" }, new string[] { "11", "21" }); db.Update <School>(new School() { id = 11, name = "xx" }); //整个实体更新 db.Update(new School { id = id, name = "蓝翔2" }); db.Update <School>(new School { id = id, name = "蓝翔2" }, it => it.id == id); //设置不更新列 db.DisableUpdateColumns = new string[] { "CreateTime" };//设置CreateTime不更新 TestUpdateColumns updObj = new TestUpdateColumns() { VGUID = Guid.Parse("542b5a27-6984-47c7-a8ee-359e483c8470"), Name = "xx", Name2 = "xx2", IdentityField = 0, CreateTime = null }; //CreateTime将不会被更新 db.Update(updObj); //以前实现这种更新需要用指定列的方式实现,现在就简单多了。 } }
protected void Page_Load(object sender, EventArgs e) { int id = 1; using (var db = SugarDao.GetInstance()) { //指定列更新 db.Update <School>(new { name = "蓝翔2" }, it => it.id == id); db.Update <School, int>(new { name = "蓝翔2" }, 1, 3, 12); db.Update <School, string>(new { name = "蓝翔2" }, new string[] { "1", "2" }); //整个实体更新 db.Update(new School { id = id, name = "蓝翔2" }); db.Update <School>(new School { id = id, name = "蓝翔2" }, it => it.id == id); //设置不更新列 db.DisableUpdateColumns = new string[] { "CreateTime" };//设置CreateTime不更新 TestUpdateColumns updObj = new TestUpdateColumns() { VGUID = Guid.Parse("6DF396EB-D1C8-48A5-8BE1-D58D685646A7"), Name = "xx", Name2 = "xx2", IdentityField = 0, CreateTime = null }; //CreateTime将不会被更新 db.Update(updObj); //以前实现这种更新需要用指定列的方式实现,现在就简单多了。 } }