Thanks for the reply. I need data from all the tables. I am using fluent nhibernate How do I perform the in clause on the above mentioned with an ICriteria?
Thanks again On Aug 3, 9:08 pm, José F. Romaniello <[email protected]> wrote: > I think you should not use many-to-many because you have a property in the > middle table... so map the middle as an Entity... > > <class name="TableA"> > <id name="ID"> > <generator class="hilo"> > </generator> > </id> > <property name="Name"/> > <set name="TableATableB" inverse="false"> > <key column="TableAID "/> > <one-to-many class="TableATableB" /> > </set> > </class> > > <class name="TableB"> > <id name="ID"> > <generator class="hilo"> > </generator> > </id> > <property name="Name"/> > </class> > > <class name="TableBType"> > <id name="ID"> > <generator class="hilo"> > </generator> > </id> > <property name="Name"/> > </class> > > <class name="TableATableB"> > <composite-id> > <key-many-to-one name="TableA" /> > <key-many-to-one name="TableB" /> > <key-many-to-one name="TableBType" /> > </composite-id> > </class> > > 2010/8/3 thecodefool <[email protected]> > > > > > Hi my question, I hope is a simple one > > > I have four tables > > > TableA > > TableAId > > Name > > > TableB > > TableBId > > Name > > > TableBType > > TableBTypeId > > Name > > > TableA_TableB > > TableAId > > TableBId > > TableBTypeId > > > I have normal classes for each nothing fancy, but I do not have a > > class TableA_TableB (Not sure what to do) > > > I would like to create the following using an ICriteria but I cannot > > for the life of me figure it out. > > > SELECT a.* FROM TableA a > > INNER JOIN TableA_TableB ab ON a.TableAId = ab.TableAId > > WHERE ab.TableBTypeId IN(1,2,3) > > > Any help is greatly appreciated > > > Thanks > > > -- > > You received this message because you are subscribed to the Google Groups > > "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<nhusers%[email protected] > > > > > . > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
