Hi Ricardo, it is a paged query. I'm using QueryOver. see the code bellow. The countQuery object executes the query with subselect.
var query = Session.QueryOver<T>(); // aply filters on query var dataQuery = query.Skip(pageParameter.Skip) .Take(pageParameter.Take) .Future<TViewModel>(); var countQuery = query.Clone(); countQuery.ClearOrders(); var total = countQuery.Select(Projections.RowCountInt64()) .FutureValue<long>() .Value; var data = dataQuery.ToList(); return new PagedList<TViewModel>(data, total); On Thu, Mar 2, 2017 at 12:32 PM, Ricardo Peres <[email protected]> wrote: > 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] >> > -- > 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. > -- ______________________________________ 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.
