public void Insert_Normal() { var insertUser = new InsertUserVO() { PassWord = "******", UserName = "******" }; // 存储过程 Table.Data.InsertUser.Execute(insertUser); Assert.IsTrue(insertUser.ID > 0); }
public void Insert_Transaction() { using (var context = new Table()) { var insertUser = new InsertUserVO() { PassWord = "******", UserName = "******" }; // 存储过程 context.InsertUser.Execute(insertUser); Assert.IsTrue(insertUser.ID > 0); context.SaveChanges(); } }
public void Transaction_Insert() { using (var context = new Table()) { int ID; var userInfo = new UserVO() {UserName = "******", GetDate = DateTime.Now}; var insertUser = new InsertUserVO() {PassWord = "******", UserName = "******"}; // 将标识设置到标识字段 context.User.Insert(userInfo, true); Assert.IsTrue(userInfo.ID > 0); // 设置out ID userInfo.ID++; context.User.Insert(userInfo, out ID); Assert.IsTrue(userInfo.ID > 0 && userInfo.ID == ID); // 缓存表 context.UserRole.Insert(new UserRoleVO {Caption = "标题", Descr = "不清楚"}); // 不同逻辑删除方式新入(主键为GUID) context.Orders.Insert(new OrdersVO {ID = Guid.NewGuid(), OrderNo = "12345678-1", CreateAt = DateTime.Now, CreateName = "用户1"}); context.OrdersAt.Insert(new OrdersVO {ID = Guid.NewGuid(), OrderNo = "12345678-2", CreateAt = DateTime.Now, CreateName = "用户1"}); context.OrdersBool.Insert(new OrdersVO {ID = Guid.NewGuid(), OrderNo = "12345678-3", CreateAt = DateTime.Now, CreateName = "用户1"}); context.OrdersNum.Insert(new OrdersVO {ID = Guid.NewGuid(), OrderNo = "12345678-4", CreateAt = DateTime.Now, CreateName = "用户1"}); context.OrdersBoolCache.Insert(new OrdersVO {ID = Guid.NewGuid(), OrderNo = "12345678-5", CreateAt = DateTime.Now, CreateName = "用户1"}); // 存储过程 Table.TransactionInstance(context).InsertUser.Execute(insertUser); Assert.IsTrue(insertUser.ID > 0); // 配置SQL Table.TransactionInstance(context).InsertNewUser.Execute(); // 手动SQL var table = Table.TransactionInstance(context); table.ManualSql.Execute("INSERT INTO Members_User (UserName,PassWord) VALUES(@UserName,@PassWord)", table.DbProvider.CreateDbParam("UserName", "steden1"), table.DbProvider.CreateDbParam("PassWord", "steden1")); context.SaveChanges(); } }