学步园

 

 

            using (var context = new EFDemoEntities())
            {
                int pageIndex = 0;
                int pageSize = 3;
                var orders = context.Orders.Where(o => o.OrderID > 2)
                .OrderByDescending(o => o.OrderID)
                .Skip(pageIndex * pageSize)
                .Take(pageSize);
                Console.WriteLine("Orders ");
                foreach (var order in orders)
                {
                    Console.WriteLine("order:{0} ,{1}]", order.OrderID, order.OrderDate);
                }
            }

 

 

            using (var context = new EFDemoEntities())
            {
                int pageIndex = 0;
                int pageSize = 3;
                string sortDirection = "asc";
                var esql = @"select value o from Orders as o
                    order by o.OrderID " + sortDirection +
                   " skip @Skip limit @Limit";
                Console.WriteLine("\nOrders");
                var orders = context.CreateQuery<Order>(esql, new[]
                    {
                        new ObjectParameter("Skip",pageIndex * pageSize),
                        new ObjectParameter("Limit",pageSize)
                    }
                );
                foreach (var order in orders)
                {
                    Console.WriteLine("order:{0}, {1}]", order.OrderID, order.OrderDate);
                }
            }