CODEWITHSUNDEEP
nhibernatehql
Gizmo
Gizmo

Reputation: 941

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

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?

Upvotes: 4

Views: 5406

Answers (1)

Jamie Ide
Jamie Ide

Reputation: 49271

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.

Upvotes: 7

Related Questions