RenameIndexOperation error in MVC5 while doing update-database

Question

I have a model named Category and you can find it's definition below:

public class Category
{
    [Key]
    public int CategoryID { get; set; }

    public string CategoryName { get; set; }

    public virtual ICollection<Subcategory> Subcategories { get; set; }
}

Subcategory is my another model, which is defined in a similar way. Afterwards, I created a new controller using this model, and named the controller CategoriesController. Then I run the command: Add-Migration Categories, and it created this:

public partial class Categories : DbMigration
    {
        public override void Up()
        {
            DropForeignKey("dbo.Services", "Category_CategoryID", "dbo.Categories");
            DropIndex("dbo.Services", new[] { "Category_CategoryID" });
            RenameColumn(table: "dbo.Services", name: "Subcategory_SubcategoryID", newName: "SubcategoryID");
            RenameIndex(table: "dbo.Services", name: "IX_Subcategory_SubcategoryID", newName: "IX_SubcategoryID");
            AddColumn("dbo.Subcategories", "CategoryID", c => c.Int(nullable: false));
            CreateIndex("dbo.Subcategories", "CategoryID");
            AddForeignKey("dbo.Subcategories", "CategoryID", "dbo.Categories", "CategoryID", cascadeDelete: true);
            DropColumn("dbo.Services", "Category_CategoryID");
        }



public override void Down()
    {
        AddColumn("dbo.Services", "Category_CategoryID", c => c.Int(nullable: false));
        DropForeignKey("dbo.Subcategories", "CategoryID", "dbo.Categories");
        DropIndex("dbo.Subcategories", new[] { "CategoryID" });
        DropColumn("dbo.Subcategories", "CategoryID");
        RenameIndex(table: "dbo.Services", name: "IX_SubcategoryID", newName: "IX_Subcategory_SubcategoryID");
        RenameColumn(table: "dbo.Services", name: "SubcategoryID", newName: "Subcategory_SubcategoryID");
        CreateIndex("dbo.Services", "Category_CategoryID");
        AddForeignKey("dbo.Services", "Category_CategoryID", "dbo.Categories", "CategoryID", cascadeDelete: true);
    }
}

Finally, in my configuration file, I added the following lines of code:

var categories = new List<Category>
            {
                new Category { CategoryName = "Sport" },
                new Category { CategoryName = "Music" }
            };

            categories.ForEach(c => context.Categories.AddOrUpdate(p => p.CategoryName, c));
            context.SaveChanges();

Finally, I ran the Update-Database command to update my database, and create a new table with this name. But unfortunately I get the error message saying RenameIndexOperation, and it doesn't update the database. Can someone tell me how can I solve this problem, and update my database successfully? Please also note that I used to create a lot of migrations and do a lot of database updates, then I did remove my migrations from my project. Those may be causing problem. I don't know if there is any command to reset my last migrations.

Answer 1

I am having the same issue.

I tried writing a drop/create index instead but that is asking for datatypes to be included, and i am unsure how to do that. (haven't looked yet)

To answer your last question you can "reset" your migration by deleting the records from the _migrationhistory table of the database you are trying to update.

When a migration starts it checks that table to know what the last migration was that was applied. So if its empty it will run your current migration as the initial migration.