示例#1
0
 /// <summary>
 /// 查找所有班级;
 /// </summary>
 /// <returns>班级列表</returns>
 public static List <Class> FindAll()
 {
     using (var eduBase = EfHelper.GetDbContext())
     {
         var classes = from c in eduBase.Class
                       select c;
         return(classes.ToList());
     }
 }
        /// <summary>
        /// 查找指定页码的所有学生;
        /// </summary>
        /// <param name="pageIndex">页码</param>
        /// <returns>学生绑定列表</returns>
        public IEnumerable <Student> FindAll(int pageIndex)
        {
            this.EduBase = EfHelper.GetDbContext();
            var students = from s in this.EduBase.Student
                           orderby s.No ascending
                           select s;
            int previousRowCount = (pageIndex - 1) * this.PageSize;
            var studentsPage     = students.Skip(previousRowCount).Take(this.PageSize);

            studentsPage.Load();
            return(this.EduBase.Student.Local.ToBindingList());
        }
示例#3
0
 /// <summary>
 /// 初始化数据库;
 /// </summary>
 /// <returns></returns>
 public static bool InitDb()
 {
     using (var eduBase = EfHelper.GetDbContext())
     {
         if (eduBase.Database.Exists())
         {
             eduBase.Database.ExecuteSqlCommand("SELECT pg_terminate_backend(A.pid) FROM pg_stat_activity AS A WHERE A.datname='EduBaseDemo' AND A.pid<>pg_backend_pid();");
         }
         eduBase.Database.Delete();
         return(eduBase.Database.CreateIfNotExists());
     }
 }
 /// <summary>
 /// 构造函数;
 /// </summary>
 public StudentRepository()
 {
     this.EduBase  = EfHelper.GetDbContext();
     this.PageSize = 6;
 }