public void Method106() { var repo = new UserRepository(); var user = new SysUser() { UserName = "******", Password = "******", UserExpand = new SysUserExpand { ExpandValue1 = "user106的补充" } }; repo.Insert(user); long id = repo.Entities.Include(p => p.UserExpand).SingleOrDefault(o => o.UserName == "user106").Id; var newUser = repo.Query(id); repo.Delete(newUser, false); var repo1 = new UserExpandRepository(); var newUserExpand = repo1.Query(id); repo1.Delete(newUserExpand, false); repo.Save(); }
//两表同时修改 public void Method104() { var repo = new UserRepository(); var user = new SysUser() { UserName = "******", Password = "******", UserExpand = new SysUserExpand { ExpandValue1 = "user104的补充" } }; repo.Insert(user); SysUser newUser = repo.Entities.Include(p => p.UserExpand).SingleOrDefault(o => o.UserName == "user104"); newUser.UserName = "******"; newUser.UserExpand.ExpandValue1 = "修改的user104的补充"; repo.Update(newUser, false); var repo1 = new UserExpandRepository(); repo1.Update(newUser.UserExpand, false); repo.Save(); }
//一步新增,通过UserExpand仓储 public void Method101() { var repo = new UserExpandRepository(); var userExpand = new SysUserExpand() { ExpandValue1 = "user101的补充", User = new SysUser() { UserName = "******", Password = "******" } }; repo.Insert(userExpand); }
//两步新增,从上面Context的测试可以看到只能从表新增 public void Method103() { var repo = new UserRepository(); var user = new SysUser() { UserName = "******", Password = "******", }; repo.Insert(user); var newUser = repo.Entities.SingleOrDefault(o => o.UserName == "user103"); newUser.UserExpand = new SysUserExpand() { Id = newUser.Id, ExpandValue1 = "user103的补充" }; repo.Update(newUser); var repo1 = new UserExpandRepository(); repo1.Insert(newUser.UserExpand); }