EF四种方式的增、删、改、查

1.新增

RbacDBEntities db = new RbacDBEntities();
            //方式1 Add
            Role r1 = new Role()
            {
                Name = "方式1",
                Remark = "备注1"
            };
            db.Roles.Add(r1);
            db.SaveChanges();
            //方式2
            Role r2 = new Role()
            {
                Name = "方式2",
                Remark = "备注2"
            };
            db.Entry(r2).State = System.Data.Entity.EntityState.Added;
            db.SaveChanges();
            //方式3调用方sql
            string sql = @"insert into roles values('方式3','备注3')";
            db.Database.ExecuteSqlCommand(sql);
            db.SaveChanges();
            //方式4，调用存储过程
            db.cp_insert_role("方法4", "备注4");
            Console.Read();

2.删除

RbacDBEntities db = new RbacDBEntities();
            //方式1 Add
            Role r1 = db.Roles.Find(1074);
            db.Roles.Remove(r1);
            db.SaveChanges();
            //方式2
            Role r2 = new Role()
            {
                ID = 1075

            };
            db.Entry(r2).State = System.Data.Entity.EntityState.Deleted;
            db.SaveChanges();
            //方式3调用方sql
            string sql = @"delete roles  where id=1076";
            db.Database.ExecuteSqlCommand(sql);
            db.SaveChanges();
            //方式4，调用存储过程
            db.cp_delete_role(1077);
            Console.Read();

3.修改

 RbacDBEntities db = new RbacDBEntities();
            //方式1 Add
            Role r1 = db.Roles.Find(1074);
            r1.Name = "修改1";
            r1.Remark = "修改备注1";
            db.SaveChanges();
            //方式2
            Role r2 = new Role()
            {
                ID = 1075,
                Name = "修改2",
                Remark = "修改备注2"
            };
            db.Entry(r2).State = System.Data.Entity.EntityState.Modified;
            db.SaveChanges();
            //方式3调用方sql
            string sql = @"update roles set name='修改3',remark='修改备注3' where id=1076";
            db.Database.ExecuteSqlCommand(sql);
            db.SaveChanges();
            //方式4，调用存储过程
            db.cp_update_role(1077, "修改4", "修改备注4");
            Console.Read();

4.查询

RbacDBEntities db = new RbacDBEntities();
            //方式1 Add
            Role r1 = db.Roles.Find(1074);
            db.Roles.Remove(r1);
            db.SaveChanges();
            //方式2
            Role r2 = new Role()
            {
                ID = 1075

            };
            db.Entry(r2).State = System.Data.Entity.EntityState.Deleted;
            db.SaveChanges();
            //方式3调用方sql
            string sql = @"delete roles  where id=1076";
            db.Database.ExecuteSqlCommand(sql);
            db.SaveChanges();
            //方式4，调用存储过程
            db.cp_delete_role(1077);
            Console.Read();