Error migrating to Entity Framework, the table is not updated

Question

I add a new field to the class User - IdentiyUser, after which I ran

add-migration [name]

This creates a migration file, but after executing update-database command, I get two errors.

I tried to delete the database and create it with its migration, the database is created, the column with my field is added, but the errors are the same

Failed executing DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
CREATE TABLE [AspNetRoles]
(
[Id] nvarchar(450) NOT NULL,
[Name] nvarchar(256) NULL,
[NormalizedName] nvarchar(256) NULL,
[ConcurrencyStamp] nvarchar(max) NULL,
CONSTRAINT [PK_AspNetRoles] PRIMARY KEY ([Id])
);

There is already an object named 'AspNetRoles' in the database.

Migration

protected override void Up(MigrationBuilder migrationBuilder)
{
    migrationBuilder.RenameColumn(
            name: "Balance",
            table: "AspNetUsers",
            newName: "Age");
}

protected override void Down(MigrationBuilder migrationBuilder)
{
    migrationBuilder.RenameColumn(
            name: "Age",
            table: "AspNetUsers",
            newName: "Balance");
}

Are you sure the error occurs on this specific migration? Because this migration has nothing to do with AspNetRoles as indicated in the error message. — Amir Molaei, May 04 '19 at 08:08
How many migrations do you have? and how long are they? I'm asking to see if it's possible to share them all. — Amir Molaei, May 04 '19 at 08:11
At the moment, one, because I deleted the migration folder, it was not worth it? — pitten, May 04 '19 at 08:15
There must be a migration file that includes creation code for `AspNetRoles` table which already exists in your database. — Amir Molaei, May 04 '19 at 08:24
https://stackoverflow.com/questions/24169140/there-is-already-an-object-named-aspnetroles-in-the-database @pitten — Masoud Andalibi, May 04 '19 at 08:39

Elvis Jr · Answer 1 · 2019-05-04T17:51:34.220

2

when you delete the migrations to create just one you should delete the database because the tables are created and you get that error. The faster solution in this case is delete all migrations folder and database and start all over.

edited May 04 '19 at 17:51

answered May 04 '19 at 13:10

Elvis Jr

125
6

score 0 · Answer 2 · answered Nov 12 '20 at 22:58

0

[Column(TypeName ="nvarchar(250)")] - Check the paranthese closing and Quotations(I rectified the error here)
Delete the Migration
Ad-Migration "InitialCreate"
Update-Database -verbose

answered Nov 12 '20 at 22:58

Nithya

17
2

score 0 · Answer 3 · answered Mar 30 '21 at 14:31

0

There is already an object named 'AspNetRoles' in the database. You must delete 'AspNetRoles' databese with connections and then You must made update database again. if not again, make database name AspNetRoles1

answered Mar 30 '21 at 14:31

Can Çatalbaş

15
3

Error migrating to Entity Framework, the table is not updated

3 Answers3