using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace ConsoleApp1
{classProgram{staticvoidMain(string[] args){using(RbacDBEntities db =newRbacDBEntities()){//方式一var role = db.Roles.Find(1);
role.Name ="方式一";
role.Remark ="备注一";
db.SaveChanges();//方式二Role role2 =newRole(){
ID=2,
Name="方式二",
Remark="备注二"};
db.Entry(role2).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();//方式三string role3 =@"update roles set name='方式三',remark='备注三' where id=3";
db.Database.ExecuteSqlCommand(role3);//方式四
db.cp_update_role(4,"方式四","备注四");
Console.Read();}}}}
删除的四种方式
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace ConsoleApp1
{classProgram{staticvoidMain(string[] args){using(RbacDBEntities db =newRbacDBEntities()){//方式一var role = db.Roles.Find(1);
db.Roles.Remove(role);
db.SaveChanges();//方式二Role role2 =newRole(){
ID=5};
db.Entry(role2).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();//方式三string role3 =@"delete roles where id=5";
db.Database.ExecuteSqlCommand(role3);//方式四
db.cp_delete_role(5);
Console.Read();}}}}
查询的四种方式
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace ConsoleApp1
{classProgram{staticvoidMain(string[] args){using(RbacDBEntities db =newRbacDBEntities()){//方式一var role = db.Roles.Where(p=>p.Name.Contains("主任")).ToList();//方式二方法查询语法var role2 =from p in db.Roleswhere p.Name.Contains("方式")select p;//方式三调用sql语句string role3 =@"select * from roles where name like'%方%'";
db.Database.SqlQuery<Role>(role3);//方式四
db.cp_select_role("方法");//或List<cp_select_role_Result> roles = db.cp_select_role("方法").ToList();
Console.Read();}}}}