How to map IList<string> with NHIbernate Mapping by code?

Question

I have this class

public class Users {
   ...
   public IList<string> Roles {get; set;}
}

I must map it to a DB schema that looks like this:

CREATE TABLE Users (
   AppId NVARCHAR(255) NOT NULL,
   ...
   PRIMARY KEY (AppId)
)

CREATE TABLE UserRoles (
   AppId NVARCHAR(255) NOT NULL,
   Role  NVARCHAR(255) NOT NULL,
   PRIMARY KEY (AppId, Role)
)

ALTER TABLE UserRoles ADD CONSTRAINT FK_UserRoles_Users FOREIGN KEY (AppId) REFERENCES Users

How do I get that with mapping-by-code? This one is close but the "Role" column has the wrong name (NHibernate names it "Id")

public UsersMapping()
{
   Id(x => x.AppId, m => m.Generator(Generators.Assigned));

   Bag(c => c.UserRoless, m =>
   {
      m.Table("UserRoles");
      m.Inverse(false);
      m.Lazy(CollectionLazy.NoLazy);
      m.Key(k =>
      {
         k.Columns(cm => cm.Name("AppId"));
         k.ForeignKey("FK_UserRoles_Users");
      });
   });
}

Andrew Whitaker · Accepted Answer · 2014-12-19 23:12:34Z

1

You were pretty close, just need to configure the element side:

public UsersMapping()
{
    Table("Users");
    Id(x => x.AppId, m => {
        m.Generator(Generators.Assigned);
        m.Column("AppId");
    });

    Bag(c => c.Roles, m =>
    {
        m.Table("UserRoles");
        m.Inverse(false);
        m.Lazy(CollectionLazy.NoLazy);
        m.Key(k =>
        {
            k.Columns(cm => cm.Name("AppId"));
            k.ForeignKey("FK_UserRoles_Users");
        });
    }, m => {
        // map the element part of the relationship:
        m.Element(el => el.Column("Role"));
    });
}

answered Dec 19, 2014 at 23:12

Andrew Whitaker

126k32 gold badges296 silver badges308 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

dstj Over a year ago

Thanks, but that also creates an id UNIQUEIDENTIFIER not null in the UserRoles table...

Collectives™ on Stack Overflow

How to map IList<string> with NHIbernate Mapping by code?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related