tags:

views:

7

answers:

0
Q: 

NHibernate many-to-many self referencing joins

I have a site where a person can follow someone and also be followed. I am not sure how to map this for my specific scenario. My database schema is currently like this

A Person table with a PersonID, Name etc. A PersonFollow table with PersonFollowID (Identity), PersonID, FollowID, Timestamp. The PersonID represents a user while the FollowID represents the ID of who they are following.

I need to be able to return a list of People who a specific person follows and also be able to return a list of who that person's followers are. What is the most efficient way to map this?

related questions

NHibernate: how to enable lazy loading on one-to-one mapping
NHibernate mapping - one-to-one (or one-to-zero)
NHibernate child to polymorphic parent mapping
How to map to get value from primary table in Nhibernate?
How can i view the mapping configurations passed to the NHibernate by the castle activerecord?
Could we have custom name of the primary key column in Fluent NHibernate?
Using Additional Data on Intermediate Table with NHibernate
Storing a comma separated list in a field using nHibernate
Normalizing EnumStringType in NHibernate
NHibernate mapping with a class hierarchy whose base class is abstract and the discriminator is not a string
Can this mapping be done with (Fluent) NHibernate?
Nhibernate ValueType Collection as delimited string in DB
NHibernate Many-to-many
NHibernate: Best way to deal with intermediary table using Fluent NHibernate?
NHibernate Inheritance mapping when sub class in Separate Assemblly
Fluent NHibernate: How to create one-to-many bidirectional mapping?
NHibernate - Is there any good tools to assist you with the configuration file?
Mapping a class with multiple collection properties containing the same object type
Joining NHibernate Classes that share a common column but no foreign key
Fluent NHibernate - how to map a subclass one-to-one?
NHibernate many-to-one and unique constraint violation
NHibernate: One base class, several mappings
Is there any way to fake an ID column in NHibernate?
NHibernate: How can I combine fields from two classes?
Mapping a collection of enums with NHibernate