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);