How do I get row count using the NHibernate QueryOver api?

[Jim Geurts]

HI all,

I'm using the QueryOver api that is part of NHibernate 3.x. I would
like to get a row count, but the method I'm using returns all objects
and then gets the count of the collection. Is there a way to just
return an integer/long value of the number of rows without returning
all of the row data?

I'm currently using:

_session.QueryOver<MyObject>().Future().Count()

if it matters, that call is being used right after one like:

_session.QueryOver<MyObject>().Skip(pageId-1 *
PageSize).Take(PageSize).Future();

Thanks for any help with this,

Jim

[Tuna Toksoz]

isn't future for future queries, why do you need it ?

Just execute the query.

Tuna Toksöz
Eternal sunshine of the open source mind.

http://devlicio.us/blogs/tuna_toksoz
http://tunatoksoz.com
http://twitter.com/tehlike

--
You received this message because you are subscribed to the Google Groups "nhusers" group.
To post to this group, send email to nhu...@googlegroups.com.
To unsubscribe from this group, send email to nhusers+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.

[Richard Brown (gmail)]

I think you can use:

 

.Select(Projections.RowCount())

.List<int>();

 

... or use:

 

.RowCount()

 

Regards,

    Richard

[Mohamed Meligy]

I think you just need to make the call (Count) BEFORE the paging code (Take, Skip).

--
Mohamed Meligy
Senior Developer, Team Lead Backup (.Net Technologies - TDG - Applications)
Injazat Data Systems
P.O. Box: 8230 Abu Dhabi, UAE.

Phone:  +971 2 6992700
Direct:   +971 2 4045385
Mobile:  +971 50 2623624, +971 55 2017 621

E-mail: eng.m...@gmail.com
Weblog: http://gurustop.net

[Richard Brown (gmail)]

I suspect you'll need both the paged query and the count.

 

See the discussion here:

 

http://groups.google.com/group/nhusers/msg/0bcda99c81248e17

http://groups.google.com/group/nhusers/browse_thread/thread/16c296414aedc09d

 

There's also a method on IQueryOver called ToRowCountQuery() that will clone the query, remove the paging, and project the rowcount, allowing you to use futures too:

 

myPagedQuery

    .ToRowCountQuery()

    .Future<int>();

 

From: Mohamed Meligy

Sent: Tuesday, March 23, 2010 7:51 AM

To: nhu...@googlegroups.com

Subject: Re: [nhusers] How do I get row count using the NHibernate QueryOver api?