How to add 'included columns' in an index

89 views
Skip to first unread message

Joseph Lam

unread,
May 27, 2012, 12:14:32 AM5/27/12
to fluent-n...@googlegroups.com
I know this is how  to add a simple index:
mapping.Map(customer => customer.Column1).Index("IDX_COLUMN1");

But how do I achieve something like below?

In SQL Server:
CREATE NONCLUSTERED INDEX [IDX_FOO] ON [CUSTOMER]
{
        [COLUMN1] ASC
}
INCLUDE
( [COLUMN2] .... )
Reply all
Reply to author
Forward
0 new messages