code first 如何创建索引字段

protected override void Seed(Context context)
{
    CreateIndex(context, "ProductName", "StoreProduct", true);
}

private void CreateIndex(Context context, string field, string table, bool unique = false)
 {
            context.Database.ExecuteSqlCommand(String.Format("CREATE {0}NONCLUSTERED INDEX IX_{1}_{2} ON {1} ({3})",
                unique ? "UNIQUE " : "",
                table,
                field.Replace(",", "_"),
                field));
}  

比较简单的方法。。

更多介绍:http://stackoverflow.com/questions/8262590/entity-framework-code-first-fluent-api-adding-indexes-to-columns

原文地址:https://www.cnblogs.com/chear/p/2854312.html