EF4中分页

 

 代码

             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);
                }
            }

 

 

 

转载于:https://www.cnblogs.com/zjz008/archive/2010/07/17/1779352.html