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
– Amir Molaei, Commented May 4, 2019 at 8: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
– Amir Molaei, Commented May 4, 2019 at 8:11
At the moment, one, because I deleted the migration folder, it was not worth it? — pitten
– pitten, Commented May 4, 2019 at 8:15

Elvis Jr · Accepted Answer · 2019-05-04 17:51:34Z

3

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 4, 2019 at 17:51

answered May 4, 2019 at 13:10

Elvis Jr

1456 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

taha-mou · Accepted Answer · 2022-12-21 10:00:02Z

1

you have a duplicated object "AspNetRoles", you try to create table (object) with same name of an object who exist on Data Base already.

answered Dec 21, 2022 at 10:00

taha-mou

114 bronze badges

1 Comment

JHBonarius Over a year ago

Welcome to Stack Overflow. Why are you answering a 3,5 year old question? It was probably resolved 3,5 years ago.... You should check the dates of questions. Also: please check if nobody else has written the same answer before you.

Nithya · Accepted Answer · 2020-11-12 22:58:06Z

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, 2020 at 22:58

Nithya

172 bronze badges

Comments

Can Çatalbaş · Accepted Answer · 2021-03-30 14:31:31Z

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, 2021 at 14:31

Can Çatalbaş

156 bronze badges

Collectives™ on Stack Overflow

Error migrating to Entity Framework, the table is not updated

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related