Ricardo, consider this code for countQuery. I'm using `Take` method:
var total = countQuery.Select(Projections.RowCountInt64())
.Take(250)
.FutureValue<long>()
.Value;
On Thu, Mar 2, 2017 at 1:47 PM, Felipe Oriani <[email protected]>
wrote:
> 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]
>
--
______________________________________
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.
