EF四种方式的查询，删除，新增，修改

EF四种方式的查询，删除，新增，修改。

1.0查询

           RbacDBEntities db = new RbacDBEntities();
            //方式1 Add
            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();

2.0删除

            RbacDBEntities db = new RbacDBEntities();
            Role r1 = db.Roles.Find(1074);