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 a Fluent 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 Fluent NHibernate query then I'll try to translate it.) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Fluent NHibernate" 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/fluent-nhibernate?hl=en -~----------~----~----~----~------~----~------~--~---
