Nhibernate mapping

Question

Hi All

I am trying to map Users to each other. The senario is that users can have buddies, so it links to itself

I was thinking of this

  public class User
    {
        public virtual Guid Id { get; set; }
        public virtual string FirstName { get; set; }
        public virtual string LastName { get; set; }
        public virtual string EmailAddress { get; set; }
        public virtual string Password { get; set; }
        public virtual DateTime? DateCreated { get; set; }
        **public virtual IList<User> Friends { get; set; }**
        public virtual bool Deleted { get; set; }
    }

But am strugling to do the xml mapping.

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
                   assembly="MyVerse.Domain"
                   namespace="MyVerse.Domain" >
  <class name="User" table="[User]">
    <id name="Id">
      <generator class="guid" />
    </id>
    <property name="FirstName" />
    <property name="LastName" />
    <property name="EmailAddress" />
    <property name="Password" />
    <property name="DateCreated" />
    <property name="Deleted" />
    <set name="Friends" table="UserFriend">
      <key foreign-key="Id"></key>
      <many-to-many class="User"></many-to-many>
    </set>
  </class>
</hibernate-mapping>

Answer 1

something like

 <bag name="Friends" table="assoc_user_table" inverse="true" lazy="true" cascade="all">
  <key column="friend_id" />
  <many-to-many class="User,user_table" column="user_id" />
</bag>