I really don't want to dump a bunch of code in here, but I have no
choice. Below are some "navigation element only" entities and their
maps, as they sit. SchemaExport works and generates the db, but it's
wrong! All the pivot tables have duplicate ids, using both my
convention and the default. I'll give an example of that last. Take a
look and tell me what I'm doing wrong.
namespace SchemaGenerator.Models
{
// used to associate a role with a forum
// and add role permission overrides
public class Mask : Entity
{
// references - passed in via constructor
public virtual Role Role { get; set; }
public virtual Forum Forum { get; set; }
// maintains a list of permissions - add - remove
private IList<Permission> permissions = new
List<Permission>();
public virtual IEnumerable<Permission> Permissions { get
{ return permissions; } }
}
public class Permission : Entity
{
// contains a list of masks - read only
private IList<Mask> masks = new List<Mask>();
public virtual IEnumerable<Mask> Masks { get { return
masks; } }
// contains a list of moderators - read only
private IList<Moderator> moderators = new List<Moderator>();
public virtual IEnumerable<Moderator> Moderators { get
{ return moderators; } }
// contains a list of roles - read only
private IList<Role> roles = new List<Role>();
public virtual IEnumerable<Role> Roles { get { return
roles; } }
}
}
using FluentNHibernate.Mapping;
namespace SchemaGenerator.Models.Mapping
{
public class MaskMap : ClassMap<Mask>
{
public MaskMap()
{
Id(x => x.Id);
// references - passed in via constructor
References<Role>(x => x.Role);
References<Forum>(x => x.Forum);
// maintains a list of permissions - add - remove
HasManyToMany<Permission>(x => x.Permissions)
.Table("MaskPermissions"); // no joining entity, need
custom table name
}
}
public class PermissionMap : ClassMap<Permission>
{
public PermissionMap()
{
Id(x => x.Id);
// contains a list of masks - read only
HasManyToMany<Mask>(x => x.Masks)
.Table("MaskPermissions"); // no joining entity, need
custom table name
// contains a list of moderators - read only
HasManyToMany<Moderator>(x => x.Moderators)
.Table("ModeratorPermissions"); // no joining entity,
need custom table name
// contains a list of roles - read only
HasManyToMany<Role>(x => x.Roles)
.Table("RolePermissions"); // no joining entity, need
custom table name
}
}
}
What happens on generation is that it generate the MaskPermissions
table with the following fields:
MaskId - ok
Permission_id - not ok...
PermissionId - ok
Mask_id - not ok...
Why is it added two additional fields that don't match my convention
files?
--
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.
