Hi, Do you can use SetMaxResult and SetFirstResult of the ICriteria. tks 2009/7/31 [email protected] <[email protected]>
> > Hello, > > I need to do a query that returns the top n items from a table. > > e.g > > select top 10 * from table > > the problem is that I need it to work in sql and oracle, is there any > form > to do that with nhibernate abstraction?? > > p.s The table is very large, so I cannot retrieve all and truncate in > in memory. > > Thanx > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
