Customizing Identity table with database first

Question

Trying to build an application that uses ASP.NET Authentication with Identity.

I've been watching a video on how to do things. They add new properties directly to the ApplicationUser class and then update the database using code-first migrations.

But I'm using database first.

So I added my new properties directly to the ApplicationUser class, and I also added compatible fields to my database. But I still get an error.

The model backing the 'ApplicationDbContext' context has changed since the database was created. Consider using Code First Migrations to update the database (http://go.microsoft.com/fwlink/?LinkId=238269).

I have Googled this and found articles specifically referencing database first, but they all seem to involve using code first!

Is this even possible to do without code first any more? Or is it just the case where we will all use code first or die?

This error is because Identity uses Migrations. If you do not want to get involved in using migrations then rename or remove the migration history table from you database and the error will stop. — Kyle, Feb 05 '17 at 05:34

score 0 · Accepted Answer · answered Feb 07 '17 at 16:57

As @Kyle suggested, this is all based on the __MigrationHistory table.

I'm not sure exactly how this all works, or what the overhead is if this table is being tested against my data each time I run my software. But renaming the table gets rid of the error. And I'm now able to modify the database as I wish without errors.

Customizing Identity table with database first

1 Answers1