Entity framework migration issue

Question

0.00/5 (No votes)

See more:

I am using Entity framework and code first approach in my project. I have done some Migrations to my server database and it was working fine. now I added a few more tables and try to create a migration by `add-migration` command to the database on server.

The command runs with no error and created a migration file.

But, when I check the migration file the code in the migration file was to create all tables again to database (`create table` for already created tables are also in the up method).

When I run `Update-database` command it returned an error saying

table already exist in database.

I try it on some local database on my system and it was working fine.

Can anyone help me with this?

Is there any special permission to set in the server?

Is it because some services from visual studio getting blocked? If so how can I solve it?

What I have tried:

I check the database . It is same and __MigrationHistory table have previous data .only the migration file creation has the issue. When I created a migration file and edit it properly the update-database works. I suspect there is some service which compare both database and entity to find the difference and some how it is getting blocked. But I have no idea about such a process.

Posted 25-Jun-18 18:49pm

Jinto Jacob

Updated 4-Jul-18 0:57am

v2

Add a Solution

Comments

[no name] 26-Jun-18 12:39pm

Is there "data" in the database you need to keep?

If not, delete the tables and "create" instead of trying to migrate.

Jinto Jacob 27-Jun-18 0:03am

I need to keep the data in Database

F-ES Sitecore 4-Jul-18 7:06am

Don't use code first then, use database first. Code first is not for anything beyond basic prototyping apps.

Nitin S 4-Jul-18 7:27am

delete the migration file and generate it again

Jinto Jacob 4-Jul-18 7:29am

tried. but no success.

Nitin S 5-Jul-18 1:19am

then try deleting the tables and running update-database again

Jinto Jacob 5-Jul-18 1:38am

Not allowed to delete. The database contains important data.

Nitin S 5-Jul-18 1:40am

you created the tables manually, right? not through migration

Jinto Jacob 5-Jul-18 2:38am

The tables was created through Code first migration earlier. and the application was running for a while. For a new modification we had to add additional table to the database. That is when error occur. No problem to migration on my test server database. But error is on live application server

Nitin S 5-Jul-18 2:45am

Remove the existing Migrations folder in your project. DROP the table "__MigrationHistory" from the existing database. Now you can rebuild this history table:

PM> enable-migrations
PM> add-migration Initial -IgnoreChanges
PM> update-database
-IgnoreChanges creates empty Up() methods and it doesn't make any changes to existing objects.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)