static void Main(string[] args) { //创建修改的对象 Users change = new Users() { UNum = 10000, UName = "admin", UPass = "******" }; using (EFDemoEntities db = new EFDemoEntities()) { //将对象加入EF容器 DbEntityEntry entity = db.Entry <Users>(change); //设置对象状态 entity.State = System.Data.EntityState.Unchanged; //Modified状态 设置被修改的列 entity.Property("UNum").IsModified = false; entity.Property("UName").IsModified = true; entity.Property("UPass").IsModified = true; //保存修改 db.SaveChanges(); Console.WriteLine("数据修改成功!"); } }
static void Main(string[] args) { using (EFDemoEntities db = new EFDemoEntities()) { //创建需要删除的对象 Users del = new Users() { UNum = 10001 }; //附加到EF中 db.Users.Attach(del); //标记为删除 db.Users.Remove(del); //提交修改 db.SaveChanges(); Console.WriteLine("数据删除成功!"); } }
static void Main(string[] args) { using (EFDemoEntities db = new EFDemoEntities()) { //循环添加50个账户 for (int i = 0; i < 50; i++) { Users u = new Users() { UName = "Test" + i, UPass = "******" + i, }; db.Users.Add(u); } //保存更改 //批处理 多次添加 一次实现 db.SaveChanges(); Console.WriteLine("数据添加成功!"); } }