What are you using, LINQ? Have you tried Criteria API? RP
On Thursday, March 2, 2017 at 3:20:38 PM UTC, Felipe Oriani wrote: > > Hello guys, > > We have been using NHibernate in a project with Oracle database. We have a > count query that nhibernate is not returning what we want. The query result: > > select > y0_ > from ( > SELECT > count( > *) > as y0_ > FROM Table1 this_ > inner join .... > where .... ) > > where rownum <=250 /* :p3 */ > > > The problem is that the count return more than 250 records. I would like > to count over the conditions of the main query limited a 250. If NHibernate > make a query like this: > > SELECT count(*) > FROM Table1 this_ > inner join .... > where .... > and rownum <=250 > > Is there any way to avoid this subquery on the count? > > Thank you > > > -- > ______________________________________ > Felipe B Oriani > [email protected] <javascript:> > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
