In hql would be something like: select a.StudyCard.Student from Appoiment a where a.Teacher = :teacher
2011/1/2, Nadav Ben-Gal <[email protected]>: > Hey, > > i want to create something like the following query: > uow.Session.QueryOver<CalendarAppointment>() > .Where( sc => > sc.Teacher == device.Teacher) > > .JoinQueryOver<StudyCard>(ca > => ca.StudyCard) > . > . > .List<Student>(); > > > my problem is the ",List<Student>();" - its not supposed to work that > way :)... > > the reason i want it - the connection between CalendarAppointment and > Student is via StudyCard: > an appointment is connected to studycard (1 study card => N > appointments) and the study card is connected to students (1 student > => N study cards) > i don't want to change the entity and DB by adding another property to > the CalendarAppointment and map it to the student. > > > i searched google, this forum and i have rtfm... didn't found anything > related. > any ideas or anything obvious i missed? > > > thanks alot > Nadav > > > -- > 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. > > -- Enviado desde mi dispositivo móvil -- 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.
