I don't know the domain butselect i.Event from Invitation i where i.Person = :pPerson
2009/8/20 Brian Kendig <[email protected]> > > I have a Person table and an Event table (parties, meetings, &c.). > This many-to-many relationship is represented by an Invitation table, > which represents the invitations sent to people for events. The > Invitation table also records when the invitation was sent, whether it > was accepted, and so forth. Each Person can have many Invitations. > Each Event can also have many Invitations. > > I want to write an NHibernate query (in C#) which, given a > Person, will return a list of the Events to which he has invitations. > > Getting a list of Invitations for a given Person is easy enough, but I > don't know how to phrase the query so that rather than giving me that > list of Invitations, it instead maps each Invitation to its Event and > gives me a list of Events instead. > > How do I write a query like this? > > (I'm using NHibernate Lamba Expressions, but if you give me a standard > NHibernate query then I'll try to translate it.) > > > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
