HQL.TOP

 

        public IList<MODEL.Product> GetGallery()
        {
            IQuery query = session.CreateQuery("select p from Product p order by p.Publishdate desc");
            query.SetFirstResult(1);
            query.SetMaxResults(10);
            IList<MODEL.Product> products = query.Future<MODEL.Product>().ToList<MODEL.Product>();
            return products;
        }