or Create a profile

Home → Help and guidance →

Column order in multi-column index

vgr's Avatar

vgr

04 Nov, 2010 04:06 PM via web

Is there a way to configure exact column order in a multi-column index, when creating a mapping using Fluent NH?

  1. Support Staff 2 Posted by James Gregory on 05 Nov, 2010 01:23 PM

    James Gregory's Avatar

    What does your mapping look like?

  2. 3 Posted by vgr on 07 Nov, 2010 02:48 PM

    vgr's Avatar

    For example:

    mapping.References(x => x.SomeReference).SetAttribute("index", "IX_index");
mapping.Map(x => x.SomeField).SetAttribute("index", "IX_index");

    Produces the following Schema:

    create index IX_index on ApplicantProgramDatas (SomeField, SomeReferenceId)

    But I want to get:

    create index IX_index on ApplicantProgramDatas (SomeReferenceId, SomeField)

  3. 4 Posted by Bas on 11 Jan, 2011 12:12 PM

    Bas's Avatar

    I second this. I need this as well, but found no way to specify this. Is it possible? If not, could this be implemented? Thanks

Reply to this discussion

Preview Comments are parsed with Markdown. Help with syntax

Attached Files

    You can attach files up to 10MB

    What comes next? 'Monday Tuesday Wednesday ?????'

    3 people watching.

    • New Issue

    • Conversation Started

      The Fluent NHibernate staff has started a conversation to resolve this discussion.

    • Close the discussion

    Recent Discussions

    11 Jan, 2011 12:12 PM Column order in multi-column index
    31 Dec, 2010 09:39 AM How to map a composite-id when using interfaces (or how to change the class attribute in the key-many-to-one tag)
    26 Dec, 2010 12:37 PM LazyLoad doesn't work with HasOne
    09 Dec, 2010 09:42 AM Property formula is not working.
    08 Dec, 2010 05:24 PM Setting length on composite -key property

     

    02 Dec, 2010 09:33 PM Setting Component as Unique Key
    02 Dec, 2010 07:29 PM Conventions for ICompositeUserTypes and field overrides
    26 Nov, 2010 01:24 PM Maping details collection using interface for detail
    22 Nov, 2010 09:59 PM Mapping a view without a unique id column
    22 Nov, 2010 09:27 PM <many-to-one> and access setting