EF实体类的增删改查操作

最新推荐文章于 2024-04-01 20:45:35 发布

原创最新推荐文章于 2024-04-01 20:45:35 发布 · 3.6k 阅读

CC 4.0 BY-SA版权

            //新增
            //传统写法
            Entities es = new Entities();
            Sys_student stu = new Sys_student() {  Name = "测试" };
            es.Sys_student.Add(stu);
            es.SaveChanges();

            //通过属性来实现

            Sys_student stu = new Sys_student() { Name = "测试" };
            DbEntityEntry<Sys_student> entry = es.Entry<Sys_student>(stu);
            entry.State = System.Data.Entity.EntityState.Added;
            es.SaveChanges();

            //修改
            Entities es = new Entities();
            Sys_student stu = new Sys_student() { ID = 41, Name = "测试" };
            DbEntityEntry<Sys_student> entry = es.Entry<Sys_student>(stu);
            entry.State = System.Data.Entity.EntityState.Unchanged;
            entry.Property("Name").IsModified = true;
            es.SaveChanges();
            Console.WriteLine("修改数据成功!");

 
//删除
//传统写法
int id = 1001;
Sys_student stu = es.Sys_students.Find(id);
es.Sys_students.Remove(stu);
es.SaveChanges();
//不查找数据,直接删除
Sys_student stu = new Sys_student{ID=1001};
es.Sys_students.Attach(stu);
es.Sys_students.Remove(stu);
es.SaveChanges();