Fluent NHibernate mapping to create a clustered index with HasMany Component

Question

I have a Fluent NHibernate mapping override that I am using to create a HasMany component. Is there a way to have NH create a clustered index on the FK column in the component table? In my example below I am wanting a clustered index on the ItemDetailFk column. Thanks!

public class ItemDetailMap : IAutoMappingOverride<ItemDetail>
{
    public void Override(AutoMapping<ItemDetail> mapping)
    {
        mapping.HasMany<ItemDetailUDF>(x => x.UserDefinedFields)
            .Table("ItemUDF")
            .KeyColumn("ItemDetailFk")
            .Not.LazyLoad()
            .Fetch.Subselect()
            .Component(udfObj =>
            {
                udfObj.Map(x => x.UDFSequence);
                udfObj.Map(x => x.String0);
                udfObj.Map(x => x.String1);
                udfObj.Map(x => x.String2);

            });
    }
}

Possible duplicate of stackoverflow.com/questions/4869586/… and stackoverflow.com/questions/1356467/… — Stefan Steinegger

Firo Firo · Accepted Answer · 2011-08-11T08:23:29

By default the PK is created as the clustered index. For clustered index there is more work, see links in Stefan Steinegger's comment. But there is a way to define an index.

mapping.HasMany<ItemDetailUDF>(x => x.UserDefinedFields)
    .Table("ItemUDF")
    .KeyColumns.Add("ItemDetailFk", c => c.Index("myindex"))

Fluent NHibernate mapping to create a clustered index with HasMany Component

1 Answers