ICriteria fetch issue

yugen · **Joined:** Sat Sep 22, 2007 2:26 am **Posts:** 4

I am a newbie at NHibernate. I am using version 1.2. I have a problem with using ICriteria.

I have two entity classes like this:

Code:

public class SubFirmObj
{ ... }

public class AnnouncementObj
{
   ...
   SubFirmObj SubFirm;
}

I can get AnnouncementObj data including their "SubFirms" with a "one-SQL-Select-Query" using "inner join fetch".

Code:

IQuery q = session.CreateQuery("select a from AnnouncementObj a inner join fetch a.SubFirm sf");
List<AnnouncementObj> list = (List<AnnouncementObj>)q.List<AnnouncementObj>;

But I cannot refactor my code to use ICriteria. Is it possible to fetch "SubFirms" with ICriteria.

Thanks for your help.

jta · **Posted:** Sun Mar 16, 2008 1:25 pm

Code:

IList<AnnouncementObj> list = session.CreateCritery(typeof(AnnouncementObj).SetFetchMode("SubFirm", FetchMode.Join).List<AnnouncementObj>();

yugen · **Joined:** Sat Sep 22, 2007 2:26 am **Posts:** 4

jta wrote:

Code:

IList<AnnouncementObj> list = session.CreateCritery(typeof(AnnouncementObj).SetFetchMode("SubFirm", FetchMode.Join).List<AnnouncementObj>();

Thanks for your reply.

I used some code like this code before, but I took this error:
The value "System.Object[]" is not of type "AnnouncementObj" and cannot be used in this generic collection.

ICriteria.List<T>() turns me not the type T (AnnouncementObj in this code), but it turns a list of System.Object array that includes AnnouncementObj and SubFirmObj.

It is strange. I am missing something, I think.

edit :

Oh sorry, I tried and saw that it worked for my question. Thanks a lot.
But I have a complex scenario. My code like this:

Code:

ICriteria c = session.CreateCriteria(typeof(AnnouncementObj));
//Add criteria expressions, bla bla...
c.SetProjection(Projections.Count("AnnouncementId"));
int rowCount = (int)c.List()[0];
c.SetProjection(null);

c.SetFetchMode("SubFirm", FetchMode.Join);
List<AnnouncementObj> = (List<AnnouncementObj>)c.List<AnnouncementObj>();

I need rowcount of my query for paging. If I comment this part, it works. But SetProjection (or maybe first "List") makes something wrong.

I think, I found the "strange" thing. Any ideas for this strange thing??

jta · **Posted:** Sun Mar 16, 2008 4:44 pm

You want to get both the count of objects and the list??? If you fetch the list anyways why dont you just access the count property on the returned list?

yugen · **Joined:** Sat Sep 22, 2007 2:26 am **Posts:** 4

I get the paged data, for example first 10 object of the whole list. I also need the count of whole list.
I used two ICriteria objects and solved the problem. But as I said, it is strange. SetProjection causes something different, I think.
Thanks for any help.

jta · **Posted:** Mon Mar 17, 2008 6:21 am

Take a look at multicriteria then

wolli · **Posted:** Mon Mar 17, 2008 7:07 am

I suppose SetProjection(null) does not work. NHIbernate 2.0 will contain a CriteriaTransformer for that. Until then you can try something like that

http://forum.hibernate.org/viewtopic.php?t=984458&highlight=projectionlist