I am doing this:



How do I transform this into a COUNT() query? (I just want the number of items returned without calling .List()). I tried a bunch of ways at no avail ...

Also, FREETEXT doesn't seem to work with CreateQuery(), but I think it should since it's just a WHERE statement, specific to MSSQL.

Thx
-dB.

Well if you don't need the objects themselves, then you don't really need NHibernate. Just get the connection from a session and execute your command directly.

This is possible in theory, but is becoming a really bad idea in practice.

It's clearly a shortcut in terms of development practices and I don't want to encourage using the SQL connection directly since the entire application standardizes on NH. We do COUNT elsewhere in an NH query. Also, the connection object is not accessible in the context on purpose, so I don't want to abandon that easily :)

In addition, I am hoping that one day NHibernate can, for example, do a great job caching objects returned from a FREETEXT query. Then I'll ask NH the count instead of SQL.

So is this impossible right now?

Much appreciated,
dB.

I got the same problem. I cannot create a new transaction with the connection in Nhibernate (using SQL Server), and dont really want to interrupt the session. and I do not want to do it as suggested above.

Why will it only allow to return class types?

Can i get something like below to work?

sergey, im tryign what you suggested, getting the current connection. However it says that I cannot execute my transaction because hibernate is in the middle of pending transaction.

I tried to do a flush of the session but that didnt work.

Since im using sql server i cannot open another transaction when one is pending.

Any ideas? For now i have to try creating a brand new session which i do not want to have to do

If you just want the count of an entity you can do something like this:



It results in the following query to be fired:
NHibernate :select count(country0_.id) as x0_0_ from Country country0_

and I get the output as 10

please note that Country is a class. This works. Is this what you are looking for.

This isn't what you find but can help you ...

See the link:

http://jira.nhibernate.org/browse/NH-307?page=all

You will add Count property in ICriteria and it will to execute a select count in database ...