I want to be able to use Fluent API to specify more index options. I have a particular interest in SORT_IN_TEMPDB and DATA_COMPRESSION.
Want something like:
indexBuilder.IsSortedInTempDb(true);
indexBuilder.HasDataCompression(DataCompression.Page);
This can be done by following the pattern set by the fill factor option - #20634.
SORT_IN_TEMPDB can be ON or OFF
DATA_COMPRESSION has the options NONE, ROW, and PAGE (link)
I could work this if determined it would be a good first issue.