Projections

I have read the documentation for 1.2beta2-Projections, and there are a few examples but they never use the value returned from the query.

What exactly is being returned, eg in the results list below, as an IList? I don't really understand why it doesn't use generics.

IList results = session.CreateCriteria(typeof(Cat))
.SetProjection( Projections.RowCount() )
.Add( Expression.Eq("Color", Color.BLACK) )
.List();

But the obvious question is, how do I find out how many rows are returned after running this query?
And how we do change this query to return a list of Cat's... ?
I run this on a table that has no records, and I get an IList with a Count of 1. Which makes it perplexing.

I intuitively thought that the IList returned would contain the RowCount... maybe my intuition is crap?

Can anyone provide an example, using Projections, that uses the return value in something realistic, like getting the RowCount and using it?

I would think ity is correct: one element in side list, which stores the returned value (0 in You example).

But I do not understand, how You intend to cast the rowcount into cat?

Gert

Hello,

I think you'd better use UniqueResult to retrieve just one piece of info.

Example:


X.

Please rate this post if it helped.

Thanks, yeah the confusion for me, is in the word "stores". How or what does it store? I think the people who write the doco, assume you already know, somehow. So, I don't have to or particularly want to cast the rowcount into Cat, I just wanted to understand what this IList returned. Was it Cats or int's or what?
Looking back after seeing the answer, it's because Hibernate is so generically 'capable' that specific tasks are not so obvious. I have to call UniqueResult() on the return value and cast it to an int.

Thanks, that answers it beatifully. That is definitely the answer I was looking for ;-)