Fluent NHibernate mapping

Question

I have these classes:

public class Entity
{
  public virtual Guid Id { get; set; }
  public virtual string EntityName { get; set; }
  public virtual IDictionary<string, Property> { get; set; }
  // ...
}

public class Property
{
  public virtual int? IntValue { get; set; }
  public virtual decimal? DecimalValue { get; set; }
}

Is it possible to create Fluent NHibernate mappings so that executing the resulting schema will give these tables:

[Entities]
* Id : UNIQUEIDENTIFIER NOT NULL
* EntityName : NVARCHAR(50) NOT NULL
with a clustered index on "Id"

[Properties]
* EntityId : UNIQUEIDENTIFIER NOT NULL
* PropertyName : VARCHAR(50) NOT NULL
* IntValue : INT NULL
* DecimalValue : DECIMAL(12,6) NULL
with a clustered index on "EntityId" and "PropertyName"

Or do I need to change my classes?

An answer more verbose than yes/no will be much appreciated :)

Phill · Accepted Answer · 2010-12-16 00:52:04Z

1

Besides your clustered index which you would need to manually create, yes. Do you absolutely require FNH to generate your schema?

Why don't you just generate the schema yourself specific to your requirements and then map it accordingly.

(not tested or anything, written off the top of my head)

public class EntityMap : ClassMap<Entity>
{
    public EntityMap()
    {
        Table("Entities");

        Id(x => x.Id).GeneratedBy.GuidComb();
        Map(x => x.Name).CustomSqlType("NVARCHAR").Length(50).Not.Nullable();
        HasMany<Property>(x => x.Properties)
            .Table("Properties")
            .KeyColumn("PropertyName")
            .Inverse()
            .AsBag();
    }
}

public class PropertyMap : ClassMap<Property>
{
    public PropertyMap()
    {
        Table("Properties");

        Id(x => x.Id).GeneratedBy.GuidComb();
        Map(x => x.PropertyName).Length(50).Not.Nullable();
        Map(x => x.IntValue);
        Map(x => x.DecimalValue);
    }
}

edited Dec 16, 2010 at 0:52

answered Dec 15, 2010 at 23:46

Phill

19k7 gold badges66 silver badges104 bronze badges

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

3 Comments

Marcin Seredynski Over a year ago

I don't need FNH to generate the schema, it's just a "nice to have". How would the mapping classes look like?

Phill Over a year ago

At a guess off the top of my head I think it would be mapped something like in my edit to my answer. I added the Id and PropertyName to the Property for insert/update of properties.

Marcin Seredynski Over a year ago

Thanks, this is really close to what I have come up with so far. I will post an answer as well.

Marcin Seredynski · Accepted Answer · 2010-12-16 01:57:29Z

Here's the mapping that I have come up with:

public sealed class EntityMap : ClassMap<Entity>
{
    public EntityMap()
    {
        Table("Entities");

        Id(c => c.Id);
        Map(c => c.EntityName).CustomSqlType("nvarchar(50)").Not.Nullable();

        HasMany(c => c.Properties)
            .KeyColumn("EntityId")
            .AsMap<string>("PropertyName")
            .Component(part =>
            {
                part.Map(x => x.IntValue);
                part.Map(x => x.DecimalValue).Precision(12).Scale(6);
            });
    }
}

Schema generation yields this:

create table Entities (
   Id UNIQUEIDENTIFIER not null,
   EntityName nvarchar(50) not null,
   primary key (Id)
)

create table Properties (
   EntityId UNIQUEIDENTIFIER not null,
   IntValue INT null,
   DecimalValue DECIMAL(12, 6) null,
   PropertyName INT not null,
   primary key (EntityId, PropertyName)
)

alter table Properties 
    add constraint FK63646D8550C14DC4 
    foreign key (EntityId) 
    references Entities

Which is pretty much what I need, with an exception of the column order (minor issue) and PropertyName being nvarchar(255) instead of varchar(50) (something I actually care about).

Collectives™ on Stack Overflow

Fluent NHibernate mapping

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related