There is already an object named ‘AspNetRoles’ in the database

by 
Add-Migration InitialMigrations -IgnoreChanges

This should generate a blank “InitialMigration” file. Now, add any desired changes to the class you want. Once changes are added, run the update command again:

update-database -verbose

Now the automatic migration will be applied and the table will be altered with your changes.

Edit:
Here is a solution to migrate identity 1 to 2 Upgrading from ASP.NET.Identity 1.0 to 2.0
Use this manual migration

public override void Up()
    {
        RenameColumn(table: "dbo.AspNetUserClaims", name: "User_Id", newName: "UserId");
        RenameIndex(table: "dbo.AspNetUserClaims", name: "IX_User_Id", newName: "IX_UserId");
        DropPrimaryKey("dbo.AspNetUserLogins");
        AddColumn("dbo.AspNetUsers", "Email", c => c.String(maxLength: 256));
        AddColumn("dbo.AspNetUsers", "EmailConfirmed", c => c.Boolean(nullable: false));
        AddColumn("dbo.AspNetUsers", "PhoneNumber", c => c.String()); 
        AddColumn("dbo.AspNetUsers", "PhoneNumberConfirmed", c => c.Boolean(nullable: false));
        AddColumn("dbo.AspNetUsers", "TwoFactorEnabled", c => c.Boolean(nullable: false));
        AddColumn("dbo.AspNetUsers", "LockoutEndDateUtc", c => c.DateTime());
        AddColumn("dbo.AspNetUsers", "LockoutEnabled", c => c.Boolean(nullable: false));
        AddColumn("dbo.AspNetUsers", "AccessFailedCount", c => c.Int(nullable: false));
        AlterColumn("dbo.AspNetUsers", "UserName", c => c.String(nullable: false, maxLength: 256));
        AlterColumn("dbo.AspNetUsers", "FirstName", c => c.String(nullable: false));
        AlterColumn("dbo.AspNetUsers", "LastName", c => c.String(nullable: false));
        AddColumn("dbo.AspNetUsers", "CreatedDateTime", c => c.DateTime(nullable: false));
        AlterColumn("dbo.AspNetRoles", "Name", c => c.String(nullable: false, maxLength: 256));
        AddPrimaryKey("dbo.AspNetUserLogins", new[] { "LoginProvider", "ProviderKey", "UserId" });
        CreateIndex("dbo.AspNetUsers", "UserName", unique: true, name: "UserNameIndex");
        CreateIndex("dbo.AspNetRoles", "Name", unique: true, name: "RoleNameIndex");
        DropColumn("dbo.AspNetUsers", "Discriminator");
    }

More Related Contents:

  1. How to change type of id in Microsoft.AspNet.Identity.EntityFramework.IdentityUser
  2. ExpireTimeSpan ignored after regenerateIdentity / validateInterval duration in MVC Identity (2.0.1)
  3. How to extend available properties of User.Identity
  4. One DbContext per request in ASP.NET MVC (without IOC container)
  5. ASP.NET Identity DbContext confusion
  6. Why LINQ to Entities does not recognize the method ‘System.String ToString()?
  7. Multiple DB Contexts in the Same DB and Application in EF 6 and Code First Migrations
  8. Should services always return DTOs, or can they also return domain models?
  9. ASP.NET MVC3 and Entity Framework Code first architecture
  10. Updating user data – ASP.NET Identity
  11. Saving Many to Many relationship data on MVC Create view
  12. Prevent multiple logins
  13. What is the advantage of using async with MVC5?
  14. Defining multiple Foreign Key for the Same table in Entity Framework Code First
  15. ‘Microsoft.SqlServer.Types’ version 10 or higher could not be found on Azure
  16. How to access Facebook private information by using ASP.NET Identity (OWIN)?
  17. Merge MyDbContext with IdentityDbContext
  18. ASP.NET Core MVC: setting expiration of identity cookie
  19. Why is Asp.Net Identity IdentityDbContext a Black-Box?
  20. Use Entity framework I want to include only first children objects and not child of child(sub of sub)
  21. ASP.NET Identity – Multiple object sets per type are not supported
  22. keyword not supported data source
  23. ASP.NET (OWIN) Identity: How to get UserID from a Web API controller?
  24. Model backing a DB Context has changed; Consider Code First Migrations
  25. how to implement ASP.NET Identity to an empty MVC project
  26. MVC 5 Owin Facebook Auth results in Null Reference Exception
  27. Incompatible Data Reader Exception From EF Mapped Objects
  28. The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value
  29. Registering Web API 2 external logins from multiple API clients with OWIN Identity
  30. EntityType ‘Category’ has no key defined. Define the key for this EntityType [duplicate]

Leave a Comment