can't have same column in both a single-column index and a multi-column index?

14 views
Skip to first unread message

Joseph Lam

unread,
May 27, 2012, 1:58:57 AM5/27/12
to fluent-n...@googlegroups.com
When I do sth like this I get weird behaviors depending on the ordering of the statements (e.g. exception when creating the DB schema complaining about duplicate index, or some index not being created, or multi-column index ending up having only one column) and I can't find a combination that does what it's supposed to do:

            mapping.Map(x => x.ValuationTime).Index("idx_ValuationTime");
            mapping.Map(x => x.CreationDate).Index("idx_CreateDate");
            mapping.References(x => x.Status).Index("idx_Status");
            mapping.Map(x => x.ValuationTime).Index("idx_all");
            mapping.Map(x => x.CreationDate).Index(" idx_all");
            mapping.References(x => x.Status).Index(" idx_all");

Has anyone tried having the same column being used in a mixture of single-column and multi-column indexes?
Reply all
Reply to author
Forward
0 new messages