Fluent NHibernate and Schema update/execute - indexes on foreign keys

Question

Is there any way to specify that a foreign key should also be indexed using fluent nhibernate? MS Sql Server does not by default index foreign keys, and I would like the schema generated by the nhibernate schema generation/update tools to create these. When I just use the HasMany or HasManyToMany methods, no such indexes are created. Is this even possible with raw xml mappings?

Thanks for the help!

Answer 1

I think the 'index' attribute on a column mapping element is what you are after. If you're on the latest version of FNH, you can set this for a one-to-many like so:

HasMany(x => x.Components)
       .KeyColumns.Add("ProductId", c => c.Index("someIndex");

The same API is not yet available for many-to-many's, but it is on its way.