Mitch Wheat - Treat the cause, not the symptoms!

 

public Index CreateIndex

(

    string indexName,

    bool isClustered,

    IndexKeyType indexKeyType,

    string[] indexColumnList,  // in index column order

    bool[]   indexDescending, 

    string[] includedColumnList

)

{

    if (indexDescending != null && indexDescending.Length != indexColumnList.Length)

    {

        throw new ArgumentOutOfRangeException(

            "Either pass indexDescending as null, or with same length as indexColumnList.");

    }

 

    Index index = new Index

                  {

                      Name = indexName,

                      IndexKeyType = indexKeyType,

                      IsClustered = isClustered

                  };

 

    int i = 0;

    foreach (string indexColumnName in indexColumnList)

    {

        bool descending = (indexDescending != null) ? indexDescending[i] : false;

        IndexedColumn indexedColumn = new IndexedColumn(index, indexColumnName, descending);

        index.IndexedColumns.Add(indexedColumn);

        i++;

    }

 

    // Only add included columns for none primary or unique indexes

    if (includedColumnList != null && indexKeyType == IndexKeyType.None)

    {

        foreach (string includedColumnName in includedColumnList)

        {

            IndexedColumn indexedColumn = new IndexedColumn(index, includedColumnName);

            indexedColumn.IsIncluded = true;

            index.IndexedColumns.Add(indexedColumn);

        }

    }

 

    return index;

}