Retrieve instances by query and not using Get nor Load nor inside a collection owned by another class and you will see how it work.Btw you must ask your self why use the 'where' in a class mapping. An example is here: http://fabiomaulo.blogspot.com/2008/10/power-of-orm.html Note:" The use of <discriminator>, discriminator-value and where tags is the trick."
2009/7/1 ike bailey <vanilla...@gmail.com> > I was reading the nhibernate reference guide to figure out how to map a > table where a column is a certain value and i ran across this:5.1.3. class > > You may declare a persistent class using the class element: > > <class > name="ClassName" (1) > table="tableName" (2) > discriminator-value="discriminator_value" (3) > mutable="true|false" (4) > schema="owner" (5) > proxy="ProxyInterface" (6) > dynamic-update="true|false" (7) > dynamic-insert="true|false" (8) > select-before-update="true|false" (9) > polymorphism="implicit|explicit" (10) > where="arbitrary sql where condition" (11) > persister="PersisterClass" (12) > batch-size="N" (13) > optimistic-lock="none|version|dirty|all" (14) > lazy="true|false" (15) > /> > > > (11) > > where (optional) specify an arbitrary SQL WHERE condition to be used when > retrieving objects of this class > > > My question is how do I use this? I've tried and I'm not sure that I'm > using it right. > > Here is my mapping > > <class name="Class" table="MBR_GRP" where="GRP_TYP_CD = '12'"> > <id name="Id"> > <column name="MBGP_KEY" /> > <generator class="native" /> > </id> > > <property name="Description" column="DESCRIPT" /> > > </class> > > > -- > Isaac Bailey > > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to nhusers@googlegroups.com To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
