public static void Updateable() { Db.CodeFirst.InitTables(typeof(UnitUser)); Db.DbMaintenance.TruncateTable <UnitUser>(); Db.Insertable(new UnitUser() { USER_ID = 1, USER_ACCOUNT = "a", USER_PWD = "b", USER_NAME = "c", PWD_LASTCHTIME = DateTime.Now, PWD_ERRORCOUNT = 1, PWD_LASTERRTIME = DateTime.Now }).ExecuteCommand(); Db.Updateable(new UnitUser() { USER_ID = 1, PWD_LASTERRTIME = null }).WhereColumns(it => new{ it.PWD_ERRORCOUNT, it.PWD_LASTERRTIME }).ExecuteCommand(); Db.CodeFirst.InitTables(typeof(UnitBoolTest)); var x = new UnitBoolTest(); //Db.Updateable<UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = !it.BoolValue }).Where(it=>it.Id==1).ExecuteCommand(); //Db.Updateable<UnitBoolTest>().SetColumns(it => it.BoolValue == !it.BoolValue ).Where(it=>it.Id==1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = x.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => it.BoolValue == x.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = !x.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); //Db.Updateable<UnitBoolTest>().SetColumns(it => it.BoolValue == !x.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue == it.BoolValue).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue == true).ExecuteCommand(); //Db.Updateable<UnitBoolTest>(x).ReSetValue(it => it.BoolValue == !it.BoolValue).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).UpdateColumns(it => new { it.BoolValue }).ExecuteCommand(); UnitSaveDiary saveDiary = new UnitSaveDiary(); saveDiary.ID = 2; saveDiary.TypeID = 10; saveDiary.TypeName = "类型100"; saveDiary.Title = "标题1000"; saveDiary.Content = "内容"; saveDiary.Time = DateTime.Now; saveDiary.IsRemind = false;//无论传false/true 最终执行的结果都是以true执行的 var sql = Db.Updateable <UnitDiary>().SetColumns(it => new UnitDiary() { IsRemind = saveDiary.IsRemind, }).Where(it => it.ID == saveDiary.ID).ToSql(); UValidate.Check(sql.Key, @"UPDATE ""diary"" SET ""isremind"" = @Const0 WHERE ( ""id"" = @ID1 )", "Updateable"); sql = Db.Updateable <UnitDiary>().SetColumns(it => new UnitDiary() { TypeID = saveDiary.TypeID, }).Where(it => it.ID == saveDiary.ID).ToSql(); UValidate.Check(sql.Key, @"UPDATE ""diary"" SET ""typeid"" = @Const0 WHERE ( ""id"" = @ID1 )", "Updateable"); }
public static void Updateable() { Db.CodeFirst.InitTables(typeof(UnitUser)); Db.DbMaintenance.TruncateTable <UnitUser>(); Db.Insertable(new UnitUser() { USER_ID = 1, USER_ACCOUNT = "a", USER_PWD = "b", USER_NAME = "c", PWD_LASTCHTIME = DateTime.Now, PWD_ERRORCOUNT = 1, PWD_LASTERRTIME = DateTime.Now }).ExecuteCommand(); Db.Updateable(new UnitUser() { USER_ID = 1, PWD_LASTERRTIME = null }).WhereColumns(it => new{ it.PWD_ERRORCOUNT, it.PWD_LASTERRTIME }).ExecuteCommand(); Db.CodeFirst.InitTables(typeof(UnitBoolTest)); var x = new UnitBoolTest(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = !it.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => it.BoolValue == !it.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = x.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => it.BoolValue == x.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = !x.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => it.BoolValue == !x.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue == it.BoolValue).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue == true).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue == !it.BoolValue).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).UpdateColumns(it => new { it.BoolValue }).ExecuteCommand(); UnitSaveDiary saveDiary = new UnitSaveDiary(); saveDiary.ID = 2; saveDiary.TypeID = 10; saveDiary.TypeName = "类型100"; saveDiary.Title = "标题1000"; saveDiary.Content = "内容"; saveDiary.Time = DateTime.Now; saveDiary.IsRemind = false;//无论传false/true 最终执行的结果都是以true执行的 var sql = Db.Updateable <UnitDiary>().SetColumns(it => new UnitDiary() { IsRemind = saveDiary.IsRemind, }).Where(it => it.ID == saveDiary.ID).ToSql(); UValidate.Check(sql.Key, @"UPDATE `Diary` SET `IsRemind` = @Const0 WHERE ( `ID` = @ID1 )", "Updateable"); sql = Db.Updateable <UnitDiary>().SetColumns(it => new UnitDiary() { TypeID = saveDiary.TypeID, }).Where(it => it.ID == saveDiary.ID).ToSql(); UValidate.Check(sql.Key, @"UPDATE `Diary` SET `TypeID` = @Const0 WHERE ( `ID` = @ID1 )", "Updateable"); Db.CodeFirst.InitTables <UnitDSsdfa>(); var dt = DateTime.Now; Db.Insertable(new UnitDSsdfa() { pk = dt, value = 1 }).ExecuteCommand(); var list = new List <UnitDSsdfa>() { new UnitDSsdfa() { pk = dt, value = 2 } }; for (int i = 0; i < 100; i++) { list.Add(new UnitDSsdfa() { pk = dt, value = 2 }); } var res1 = Db.Updateable(list).WhereColumns(it => it.pk).ExecuteCommand(); }
public static void Updateable() { Db.CodeFirst.InitTables(typeof(UnitUser)); Db.DbMaintenance.TruncateTable <UnitUser>(); Db.Insertable(new UnitUser() { USER_ID = 1, USER_ACCOUNT = "a", USER_PWD = "b", USER_NAME = "c", PWD_LASTCHTIME = DateTime.Now, PWD_ERRORCOUNT = 1, PWD_LASTERRTIME = DateTime.Now }).ExecuteCommand(); Db.Updateable(new UnitUser() { USER_ID = 1, PWD_LASTERRTIME = null }).WhereColumns(it => new{ it.PWD_ERRORCOUNT, it.PWD_LASTERRTIME }).ExecuteCommand(); Db.CodeFirst.InitTables(typeof(UnitBoolTest)); var x = new UnitBoolTest(); //Db.Updateable<UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = !it.BoolValue }).Where(it=>it.Id==1).ExecuteCommand(); //Db.Updateable<UnitBoolTest>().SetColumns(it => it.BoolValue == !it.BoolValue ).Where(it=>it.Id==1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = x.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => it.BoolValue == x.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = !x.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); //Db.Updateable<UnitBoolTest>().SetColumns(it => it.BoolValue == !x.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue == it.BoolValue).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue == true).ExecuteCommand(); //Db.Updateable<UnitBoolTest>(x).ReSetValue(it => it.BoolValue == !it.BoolValue).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).UpdateColumns(it => new { it.BoolValue }).ExecuteCommand(); UnitSaveDiary saveDiary = new UnitSaveDiary(); saveDiary.ID = 2; saveDiary.TypeID = 10; saveDiary.TypeName = "类型100"; saveDiary.Title = "标题1000"; saveDiary.Content = "内容"; saveDiary.Time = DateTime.Now; saveDiary.IsRemind = false;//无论传false/true 最终执行的结果都是以true执行的 var sql = Db.Updateable <UnitDiary>().SetColumns(it => new UnitDiary() { IsRemind = saveDiary.IsRemind, }).Where(it => it.ID == saveDiary.ID).ToSql(); UValidate.Check(sql.Key, @"UPDATE ""diary"" SET ""isremind"" = @Const0 WHERE ( ""id"" = @ID1 )", "Updateable"); sql = Db.Updateable <UnitDiary>().SetColumns(it => new UnitDiary() { TypeID = saveDiary.TypeID, }).Where(it => it.ID == saveDiary.ID).ToSql(); UValidate.Check(sql.Key, @"UPDATE ""diary"" SET ""typeid"" = @Const0 WHERE ( ""id"" = @ID1 )", "Updateable"); Db.Updateable <OrderModel>().SetColumns(it => new OrderModel() { CreateTime = null }).Where(it => it.Id == 1).ExecuteCommand(); Db.CodeFirst.InitTables <BoolTest1>(); Db.Updateable <BoolTest1>() .SetColumns(it => it.a == !it.a) .Where(it => it.a) .ExecuteCommand(); Db.Updateable <BoolTest1>() .SetColumns(it => new BoolTest1() { a = !it.a }) .Where(it => it.a) .ExecuteCommand(); // Db.CodeFirst.InitTables<UnitPk00121>(); //Db.CodeFirst.InitTables<UnitPk001212>(); //Db.Deleteable<UnitPk00121>().Where(new UnitPk00121() { Id=1, CreateTime=DateTime.Now, Name="a" }).ExecuteCommand(); //Db.Deleteable<UnitPk001212>().Where(new List<UnitPk001212> { new UnitPk001212() { Id = 1, CreateTime = DateTime.Now, Name = "a" } , new UnitPk001212() { Id = 2, CreateTime = DateTime.Now, Name = "11a" } }).ExecuteCommand(); Db.CodeFirst.InitTables <UnitDSsdfa>(); var dt = DateTime.Now; Db.Insertable(new UnitDSsdfa() { pk = dt, value = 1 }).ExecuteCommand(); var list = new List <UnitDSsdfa>() { new UnitDSsdfa() { pk = Convert.ToDateTime("2022-1-1"), value = 2 }, new UnitDSsdfa() { pk = dt, value = 2 } }; var res1 = Db.Updateable(list).WhereColumns(it => it.pk).ExecuteCommand(); }
public static void Updateable() { Db.CodeFirst.InitTables(typeof(UnitUser)); Db.DbMaintenance.TruncateTable <UnitUser>(); Db.Insertable(new UnitUser() { USER_ID = 1, USER_ACCOUNT = "a", USER_PWD = "b", USER_NAME = "c", PWD_LASTCHTIME = DateTime.Now, PWD_ERRORCOUNT = 1, PWD_LASTERRTIME = DateTime.Now }).ExecuteCommand(); Db.Updateable(new UnitUser() { USER_ID = 1, PWD_LASTERRTIME = null }).WhereColumns(it => new { it.PWD_ERRORCOUNT, it.PWD_LASTERRTIME }).ExecuteCommand(); Db.CodeFirst.InitTables(typeof(UnitBoolTest)); var x = new UnitBoolTest(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = !it.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => it.BoolValue == !it.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = x.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => it.BoolValue == x.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = !x.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => it.BoolValue == !x.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue = it.BoolValue).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue = true).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue = !it.BoolValue).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).UpdateColumns(it => new { it.BoolValue }).ExecuteCommand(); UnitSaveDiary saveDiary = new UnitSaveDiary(); saveDiary.ID = 2; saveDiary.TypeID = 10; saveDiary.TypeName = "类型100"; saveDiary.Title = "标题1000"; saveDiary.Content = "内容"; saveDiary.Time = DateTime.Now; saveDiary.IsRemind = false;//无论传false/true 最终执行的结果都是以true执行的 var sql = Db.Updateable <UnitDiary>().SetColumns(it => new UnitDiary() { IsRemind = saveDiary.IsRemind, }).Where(it => it.ID == saveDiary.ID).ToSql(); UValidate.Check(sql.Key, @"UPDATE [Diary] SET [IsRemind] = @Const0 WHERE ( [ID] = @ID1 )", "Updateable"); sql = Db.Updateable <UnitDiary>().SetColumns(it => new UnitDiary() { TypeID = saveDiary.TypeID, }).Where(it => it.ID == saveDiary.ID).ToSql(); UValidate.Check(sql.Key, @"UPDATE [Diary] SET [TypeID] = @Const0 WHERE ( [ID] = @ID1 )", "Updateable"); sql = Db.Updateable <UnitDiary>().SetColumns(it => new UnitDiary() { TypeID = saveDiary.TypeID, }).Where(it => it.ID == saveDiary.ID).ToSql(); UValidate.Check(sql.Key, @"UPDATE [Diary] SET [TypeID] = @Const0 WHERE ( [ID] = @ID1 )", "Updateable"); sql = Db.Updateable <NullTest>().SetColumns(it => new NullTest() { p = true }).Where(it => it.id == 1).ToSql(); UValidate.Check(sql.Key, @"UPDATE [NullTest] SET [p] = @Const0 WHERE ( [id] = @id1 )", "Updateable"); sql = Db.Updateable <NullTest>().SetColumns(it => new NullTest() { p2 = true }).Where(it => it.id == 1).ToSql(); UValidate.Check(sql.Key, @"UPDATE [NullTest] SET [p2] = @Const0 WHERE ( [id] = @id1 )", "Updateable"); Db.Updateable <Order>() .SetColumns(it => it.Name == "a") .SetColumns(it => it.CreateTime == DateTime.Now) .SetColumns(it => it.Price == 1).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <Order>() .SetColumns(it => new Order { Name = "a", CreateTime = DateTime.Now }) .SetColumns(it => it.Price == 1).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <Order>() .SetColumns(it => new Order { Name = "a", CreateTime = DateTime.Now }) .SetColumns(it => new Order() { Price = 1 }).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <Order>() .SetColumns(it => new Order { Name = it.Id > 0 ?"1":"2", CreateTime = DateTime.Now }) .Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <Order>() .SetColumns(it => new Order { Name = SqlFunc.IsNull(it.Name, "a") + "b", CreateTime = DateTime.Now }) .Where(it => it.Id == 1).ExecuteCommand(); Db.CodeFirst.InitTables <Unitbluecopy>(); Db.Insertable(new Unitbluecopy()).UseSqlServer().ExecuteBulkCopy(); }
public static void Updateable() { Db.CodeFirst.InitTables(typeof(UnitUser)); Db.DbMaintenance.TruncateTable <UnitUser>(); Db.Insertable(new UnitUser() { USER_ID = 1, USER_ACCOUNT = "a", USER_PWD = "b", USER_NAME = "c", PWD_LASTCHTIME = DateTime.Now, PWD_ERRORCOUNT = 1, PWD_LASTERRTIME = DateTime.Now }).ExecuteCommand(); Db.Updateable(new UnitUser() { USER_ID = 1, PWD_LASTERRTIME = null }).WhereColumns(it => new{ it.PWD_ERRORCOUNT, it.PWD_LASTERRTIME }).ExecuteCommand(); Db.CodeFirst.InitTables(typeof(UnitBoolTest)); var x = new UnitBoolTest(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = !it.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => it.BoolValue == !it.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = x.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => it.BoolValue == x.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => new UnitBoolTest() { BoolValue = !x.BoolValue }).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>().SetColumns(it => it.BoolValue == !x.BoolValue).Where(it => it.Id == 1).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue = it.BoolValue).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue = true).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).ReSetValue(it => it.BoolValue = !it.BoolValue).ExecuteCommand(); Db.Updateable <UnitBoolTest>(x).UpdateColumns(it => new { it.BoolValue }).ExecuteCommand(); UnitSaveDiary saveDiary = new UnitSaveDiary(); saveDiary.ID = 2; saveDiary.TypeID = 10; saveDiary.TypeName = "类型100"; saveDiary.Title = "标题1000"; saveDiary.Content = "内容"; saveDiary.Time = DateTime.Now; saveDiary.IsRemind = false;//无论传false/true 最终执行的结果都是以true执行的 var sql = Db.Updateable <UnitDiary>().SetColumns(it => new UnitDiary() { IsRemind = saveDiary.IsRemind, }).Where(it => it.ID == saveDiary.ID).ToSql(); // UValidate.Check(sql.Key, @"UPDATE ""UNITBOOLTEST"" SET //""BOOLVALUE"" =:BoolValue WHERE ""ID"" =:Id"", "Updateable"); // sql = Db.Updateable<UnitDiary>().SetColumns(it => new UnitDiary() //{ // TypeID = saveDiary.TypeID, //}).Where(it => it.ID == saveDiary.ID).ToSql(); //UValidate.Check(sql.Key, @"UPDATE ""DIARY"" SET //""TYPEID"" = @Const0 WHERE ( ""ID"" = :ID1 )", "Updateable"); Db.CodeFirst.InitTables <UnitGuidTest>(); Db.Updateable(new List <UnitGuidTest> { new UnitGuidTest() { Id = Guid.NewGuid(), name = "a", guid = Guid.NewGuid() }, new UnitGuidTest() { Id = Guid.NewGuid(), name = "a" } }).ExecuteCommand(); var updateObjs = new List <Order> { new Order() { Id = 11, Name = "order11" } }; //update all columns by primary key if (Db.Updateable(updateObjs).ExecuteCommandAsync().GetAwaiter().GetResult() != 1) { throw new Exception("unit error"); } }