In addition to Yorro's response, characteristics can also be used to do this....example of...int...
sort special key combination:...[Index("IX_UniqueKeyInt", IsUnique = true, Order = 1)]
public int UniqueKeyIntPart1 { get; set; }
[Index("IX_UniqueKeyInt", IsUnique = true, Order = 2)]
public int UniqueKeyIntPart2 { get; set; }
...Whenever the data ...
Migrations can be manually edited as follows:...public override void Up()
{
Sql("CREATE NONCLUSTERED INDEX [IX_Index_name] ON [dbo].[TableName] ([ColumnName1] Asc,[ColumnName2] Desc,[ColumnName3] Desc)");
}
public override void Down()
{
Sql("DROP INDEX [dbo].[TableName].[IX_Index_name]");
}
