asp.netMVC增删查改的四种方式

            //四种方式新增
            //方式一
            RbacDBEntities db = new RbacDBEntities();
            Role role = new Role()
            {
                Name = "方式一",
                Remark = "备注一"
            };
            db.Roles.Add(role);
            db.SaveChanges();
            //方式二
            Role roles = new Role()
            {
                Name = "方式二",
                Remark = "备注三"
            };
            db.Entry(roles).State = System.Data.Entity.EntityState.Added;
            db.SaveChanges();
            //方式三
            string sql = @"insert into Roles values('方式三','备注三')";
            db.Database.ExecuteSqlCommand(sql);
            db.SaveChanges();
            //方式四
            db.cp_insert_role("方式四", "备注四");
            Console.Read();

 int id = int.Parse(Console.ReadLine());
            //四种方式修改
            //方式一

            RbacDBEntities db = new RbacDBEntities();
            var a = db.Roles.Find(id);
            a.Name = "方式一";
            a.Remark = "备注一";
            db.SaveChanges();
            //方式二
            int ids = int.Parse(Console.ReadLine());
            Role roles = new Role()
            {
                ID = ids,
                Name = "方式二",
                Remark = "备注三"
            };
            db.Entry(roles).State = System.Data.Entity.EntityState.Modified;
            db.SaveChanges();
            //方式三
            int idss = int.Parse(Console.ReadLine());
            string sql = @"update Roles set Name='方式三',Remark='方式三'where ID=idss";
            db.Database.ExecuteSqlCommand(sql);
            db.SaveChanges();
            //方式四
            int idsss = int.Parse(Console.ReadLine());
            db.cp_update_role(idsss,"方式四", "备注四");
            Console.Read();

 int id = int.Parse(Console.ReadLine());
            //四种方式删除
            //方式一
            RbacDBEntities db = new RbacDBEntities();
            var a = db.Roles.Find(id);
            db.Roles.Remove(a);
            db.SaveChanges();
            //方式二
            int ids = int.Parse(Console.ReadLine());
            Role roles = new Role()
            {
                ID = ids,
                Name = "方式二",
                Remark = "备注三"
            };
            db.Entry(roles).State = System.Data.Entity.EntityState.Deleted;
            db.SaveChanges();
            //方式三
            int idss = int.Parse(Console.ReadLine());
            string sql = @"delete Roles where ID=idss";
            db.Database.ExecuteSqlCommand(sql);
            db.SaveChanges();
            //方式四
            int idsss = int.Parse(Console.ReadLine());
            db.cp_delete_role(idsss);
            Console.Read();

 int id = int.Parse(Console.ReadLine());
            //四种方式模糊查询
            //方式一
            RbacDBEntities db = new RbacDBEntities();
            var roles1 = from r in db.Roles
                         where r.Name.Contains("主任")
                         select r;
            //方式2
            var roles2 = db.Roles
                .Where(p => p.Name.Contains("主任"))
                .Select(p => p).ToList();
            //方式3调用方sql
            string sql = @"select * from roles  where name like '%主任%'";
            db.Database.SqlQuery<Role>(sql);
            db.SaveChanges();
            //方式4，调用存储过程
            List<cp_select_role_Result> roles11 = db.cp_select_role("主任").ToList();
            Console.Read();