Map to different collection based on colunm

theunforgiven · **Joined:** Thu Jul 31, 2008 9:54 am **Posts:** 4

I have a table like:

Code:

                          `Id`             INT(11) NOT NULL auto_increment,
                          `stand_Id`       INT(11) NOT NULL               ,
                          `CPOX` TINYINT(1) DEFAULT NULL                  ,

Id is a PK/stand_id is an FK
What i am wondering is, with NHibernate, is it possible to map all rows with CPOX = 1 to a different collection than when CPOX = 0? i haven't found a way, but i think it might be possible with either some voodoo magic polymorphism or possibly a discriminator. Not sure, just looking to know if it is possible and what i should be trying to use. Thanks!

wolli · **Posted:** Fri Jun 05, 2009 1:26 am

Have you tried:

<bag (or set, map, list,...) name="CPOX0"...... where="CPOX=0"> ....</bag>
<bag (or set, map, list,...) name="CPOX1"...... where="CPOX=0"> ....</bag>

theunforgiven · **Joined:** Thu Jul 31, 2008 9:54 am **Posts:** 4

Oh man thanks! I'm retarded i didn't even THINK about doing that. Thanks so much =D
-- as an aside i wanted to rate your anwser but i can't figure out how, wheres the button/link for that?

wolli · **Posted:** Fri Jun 05, 2009 8:00 am

Maybe the rating stuff was removed with the new version of the forum software ...

theunforgiven · **Joined:** Thu Jul 31, 2008 9:54 am **Posts:** 4

Thats a shame. But thank you again! Worked like a charm.