How can i do select count(*) from TABLE with nHibernate without queryOver?

Question

I am using an older version of nHibernate due to my old version of .net. QueryOver isn't an option. What's an efficient way to count the rows of a table with nhibernate?

I've tried something like this: int count = (int)s.CreateQuery("select count(*) from tablename").UniqueResult(); But it will only return the number of tables not the number of rows in that specific table. — Gizmo
– Gizmo, Commented Apr 29, 2013 at 15:11

Jamie Ide · Accepted Answer · 2013-04-29 16:24:28Z

7

The HQL you show in your comment is correct:

int count = (int)s.CreateQuery("select count(*) from [classname]").UniqueResult();

This will return the number of rows in the table represented by classname.

answered Apr 29, 2013 at 16:24

Jamie Ide

49.4k18 gold badges85 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gizmo Over a year ago

s.CreateSQLQuery("select count(*) from [classname]") .UniqueResult<Int32>(); this one did it. I don't know why the other one wouldn't work. Thank you anyways.

Collectives™ on Stack Overflow

How can i do select count(*) from TABLE with nHibernate without queryOver?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related