The where attribute must contain SQL, not HQL. On Sunday, September 16, 2012 11:27:11 AM UTC+1, A_Doustkani wrote: > > Hi. I'm new to NHibernate. I have an old database that I have to do some > mappings on it. > The below database is an example of my problem (not the same). > > Database: > > <https://lh6.googleusercontent.com/-AU2DXFuCgEI/UFWm1R5DXlI/AAAAAAAAAAM/k69VRGQbj60/s1600/data+model.png> > > Class Diagram: > > <https://lh5.googleusercontent.com/-Bf6dSgQxSVk/UFWnAusZUHI/AAAAAAAAAAU/6v8CPDFFhwk/s1600/ClassDiagram1.png> > > > I want to fill MaleActors with Actors that their Sex field equals to > 'Male' and FemaleActors with Actors that their Sex field equals to 'Female' > I tried where attribute on my many-to-many relation but it doesn't work. > > Here are my Mapping files: > > *Movie.hbm.xml* > <?xml version="1.0" encoding="utf-8" ?> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" > assembly="MovieEg" namespace="MovieEg"> > <class name="Movie" table="Movies"> > <id name="Id"> > <generator class="identity"/> > </id> > <property name="Name"/> > <bag name="FActors" table="ActorRoles" > > <key column="MovieId"/> > <many-to-many class="Role" column="Id" where="Actors.Sex='Male'" > /> > </bag> > </class> > </hibernate-mapping> > > *Actor.hbm.xml* > <?xml version="1.0" encoding="utf-8" ?> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" > assembly="MovieEg" namespace="MovieEg"> > <class name="Actor" table="Actors"> > <id name="Id"> > <generator class="identity"/> > </id> > <property name="Name"/> > <property name="Sex"/> > </class> > </hibernate-mapping> > > *ActorRole.hbm.xml* > <?xml version="1.0" encoding="utf-8" ?> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="MovieEg" > namespace="MovieEg"> > <class name="Role" table="ActorRoles"> > <id name="Id"> > <generator class="identity"/> > </id> > <property name="RoleNameInMovie" column="Role"/> > <many-to-one name="Actor" class="Actor" column="ActorId" /> > </class> > </hibernate-mapping> >
-- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/4t71dV3NjTQJ. 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.
