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]
--
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.
