How to specify table name in Fluent NHibernate ClassMap class?

Question

I am newbie to NHibernate and trying to use Fluent for mapping. My entity class name is different from the database table name it has to be mapped to. I am using mapping class derived from ClassMap<>, but I can't specify the table name: the property TableName from ClassMap is read-only.

Thanks for your help.

score 45 · Accepted Answer · edited May 06 '11 at 12:22

45

Use Table("table_name") instead.

edited May 06 '11 at 12:22

vgru

49,838
16
120
201

answered Mar 11 '09 at 09:55

Spikolynn

4,067
2
37
44

9

This is now. As of Sept 2009 Table("table_name"); – Chin Sep 10 '09 at 06:25

score 6 · Answer 2 · answered Feb 24 '11 at 00:21

6

Does it work like?

public class UserAccountMap : ClassMap<UserAccount> {
    public UserAccountMap() {
        Table("User");
        Id(x => x.UserID, "UserID").GeneratedBy.Identity();
        Map(x => x.FirstName, "FirstName").Length(50)
            .Not.Nullable();
        Map(x => x.LastName, "LastName").Length(50)
            .Not.Nullable();
    }
}

answered Feb 24 '11 at 00:21

hardywang

4,864
11
65
101

1

User is a reserved keyword. enclose with `. See http://stackoverflow.com/a/2879630/475882 – jaxxbo Mar 15 '14 at 18:44

score 6 · Answer 3 · answered Oct 18 '11 at 15:05

The example above lead me in the right direction. This worked for me. My class name is "Party" and my table name is "prty.Party".

public class PartyMap : ClassMap<Party>
{
    public PartyMap()
    {
     Table("prty.Party");
     Id(x => x.PartyID);
     Map(x => x.PartyTypeLID);
     Map(x => x.OrganizationTypeLID);
     Map(x => x.PreferredContactMethodLID);
     Map(x => x.PrimaryLanguageLID);
     Map(x => x.PartyVID);
     Map(x => x.BeginDate);
     Map(x => x.EndDate);
     Map(x => x.RowDescriptor);
     Map(x => x.RowModifiedDate);
     Map(x => x.RowModifiedBy);
     Map(x => x.RowCreatedDate);
     Map(x => x.RowCreatedBy);
    }        
}

Maybe exists some way to skip all this map calls? – Ihar Krasnik Jan 09 '14 at 14:29 — Ihar Krasnik, Jan 09 '14 at 14:29

How to specify table name in Fluent NHibernate ClassMap class?

3 Answers3

Linked