private void button5_Click(object sender, EventArgs e) { Stopwatch watch = new Stopwatch(); watch.Reset(); watch.Start(); using (var db = new PermissionEntities()) { var query = db.tb.Where(t => true).OrderBy(t => t.name); //用skip之前必须OrderBy PagerResultModel <tb> tbs = PagerExtension.ToPager <tb>(query, 1000, int.Parse(textBox1.Text.Trim())); label1.Text = tbs.Count.ToString(); dataGridView1.DataSource = tbs.List; } watch.Stop(); MessageBox.Show("ExfSoft.EntityFramework.Extension耗时:" + watch.ElapsedMilliseconds); }
/// <summary>获取分页集合 /// 获取分页集合 /// </summary> /// <returns></returns> public PagerResultModel <T> GetListPaged <T, Tkey>(IQueryable <T> TSource, int Pagesize, int Pageindex) where T : class { PagerResultModel <T> PagerResultModels = PagerExtension.ToPager <T>(TSource, Pagesize, Pageindex); return(PagerResultModels); }