EF的增删改查

EF的增删改查：

using System;

using System.Collections.Generic;

using System.Data.Entity.Infrastructure;

using System.Linq;

using System.Linq.Expressions;

using System.Text;

using System.Threading.Tasks;

namespace Dal

{

publicclassStudentsDal

{

zzEntities zzDB = new zzEntities();

publicintAdd(Student model)

{

zzDB.Students.Add(model);

returnzzDB.SaveChanges();

}

publicintDeleteStu(Student model) {

zzDB.Students.Attach(model);

zzDB.Students.Remove(model);

returnzzDB.SaveChanges();

}

publicintUpdateStu(Student model,string[]propertys) {

DbEntityEntry dbEE =zzDB.Entry(model);

dbEE.State = System.Data.EntityState.Unchanged;

foreach(var pro inpropertys)

{

dbEE.Property(pro).IsModified = true;

}

returnzzDB.SaveChanges();

}

publicintDeleteStuBy(Expression<Func<Student,bool>>delWhere) {

List<Student>stuList = zzDB.Students.Where(delWhere).ToList();

stuList.ForEach(stu =>zzDB.Students.Remove(stu));

returnzzDB.SaveChanges();

}

publicList<Student>GetListBy(Expression<Func<Student,bool>>stuWhere) {

return zzDB.Students.Where(stuWhere).ToList();

}

publicList<Student>GetPageList<Tkey>(intPageIndex,int PageSize,Expression<Func<Student,bool>>stuwhere,Expression<Func<Student,Tkey>> orderBy ) {

returnzzDB.Students.Where(stuwhere).OrderBy(orderBy).Skip((PageIndex-1)*PageSize).Take(PageSize).ToList();

}

}

}