Entity FrameWork实现增、删、改、分页的数据层代码实现

public bool AddEntity(Customer entity)//添加实体
  {
      MyHotelModelContainer hotelDB = new MyHotelModelContainer();//定义上下文实体
      if (entity.Id == Guid.Empty)
      {
          entity.Id = Guid.NewGuid();
      }
      hotelDB.Customer.AddObject(entity);//调用添加实体方法
      int count = hotelDB.SaveChanges();
      if (count > 0)
      {
          return true;
      }
      return false;
  }
 
  public bool UpdateEntity(Customer entity)//更新实体
  {
      bool result = false;
      MyHotelModelContainer hotelDB = new MyHotelModelContainer();
      hotelDB.Customer.Attach(entity);
      hotelDB.ObjectStateManager.ChangeObjectState(entity, System.Data.EntityState.Modified);//调用更新实体发法
      int count = hotelDB.SaveChanges();
      if (count > 0)
      {
          result = true;
      }
      return result;
   
  }
 
  public bool DeleteEntity(Guid Id)//根具指定id删除一个实体
  {
      bool result = false;
      MyHotelModelContainer hoteDB = new MyHotelModelContainer();
      //根据id查询出要删除的实体
      var tempDelete = hoteDB.Customer.Where<Customer>(c => c.Id == Id).FirstOrDefault<Customer>();<span style="white-space:pre">    </span>
      if (tempDelete != null)//删除之前的判断
      {
          hoteDB.Customer.DeleteObject(tempDelete);//调用删除实体方法
          var count = hoteDB.SaveChanges();
          if (count > 0)
          result = true;
      }
      return result;
  }
 
  public IQueryable<Customer> GetByWhere(Func<Customer, bool> whereLambda)//根据某种条件等到实体集合  <span style="font-size:12px; font-family:Arial,Helvetica,sans-serif">IQueryable集合可以实现延迟加载功能</span>
  {<span style="white-space:pre">   </span>
      MyHotelModelContainer hoteDB = new MyHotelModelContainer();
      var temp = hoteDB.Customer.Where<Customer>(whereLambda).AsQueryable<Customer>();
      return temp;
  }
 
  public IQueryable<Customer> GetPageEntity(Func<Customer, bool> whereLambda, int? pageSize, int? pageIndex)//实现分页的方法
  {
      MyHotelModelContainer hotelDB = new MyHotelModelContainer();
      var temp = hotelDB.Customer
          .Where<Customer>(whereLambda)
          .OrderBy(c => c.FirstName)
          .Skip<Customer>(pageSize.Value * (pageIndex.Value - 1))
          .Take<Customer>(pageSize.Value)
          .AsQueryable<Customer>();
      return temp;
  }
 
 
  public long GetCount(Func<Customer, bool> whereLambda)//得到中共多少条数据
  {
      MyHotelModelContainer hotelDB = new MyHotelModelContainer();
      return hotelDB.Customer.Where<Customer>(whereLambda).Count();
  }