Fluent nHibernate Mapping questions - many to many with data.

Question

this is my db: tblGroups: GroupID GroupName

tblMembersInGroup GroupID MemberID Rank

tblMembers MemberID Name

this is my Model:

class group 
{
  int groupid
  string name
  List<EnlistedMembers> myMembers;

}

class EnlistedMebmers
{
  Member myMember;
  int Rank;
}

class Member
{  
  int MemberID
  string Name
}

I am not sure how to map this in FNH, as the Members class has no object that tells FNH who is the father.

I think the group mapping is obvious:

 Table(tblGroup);
    Id(x => x.groupid, "GroupID').GeneratedBy.Identity();
    Map(x => x.name, "GroupName");
    HasMany(x => x.myMembers).AsList().Inverse().Cascade.All();

What's next ?

how do I map enlistedmembers, with no identity object? and no group object ? but with the extra rank data. the db has all the data, I need a way to create the classes right...

Thanks,

Dani

Answer 1

Is there a reason you need to map EnlistedMembers? If not, you could map Group.MyMembers like this:

HasManyToMany(z => z.MyMembers)
                .AsList()
                .Cascade.All()
                .Table("tblMembersInGroup")
                .ParentKeyColumn("GroupId")
                .ChildKeyColumn("MemberId");

Answer 2

I suspect this may be a square peg for a round hole, but I'd look into SubClassing.

public class MemberMap : ClassMap<Member>
{
  public MemberMap()
  {
    Table("tblMembers");
    Id(x => x.MemberID);
    Map(x => x.Name);
  }
}

public class EnlistedMembersMap : SubclassMap<EnlistedMembers>
{
  public EnlistedMembersMap()
  {
    Table("tblMembersInGroup");
    Map(x => x.Rank);
  }
}

You'll need to make EnlistedMembers inherit from Member. I'm also pretty sure it's going to bark about the composite key you have going in tblMembersInGroup. I don't have an answer for that... yet.