Entity Migration. Could not drop constraint. See previous errors

c# ef-migrations entity-framework

Question

Here is the code that produce this error. I've tried solution for renaming the AddForeignKey but the error is same.

'PK_dbo.Item' is not a constraint.
Could not drop constraint. See previous errors.

Can you suggest some solution?

public override void Up()
{
    DropForeignKey("dbo.AddGallery", "item_fk_id", "dbo.Item");
    DropForeignKey("dbo.ExtraFieldValue", "item_fk_id", "dbo.Item");
    DropPrimaryKey("dbo.Item");
    AddColumn("dbo.Item", "id", c => c.Int(nullable: false, identity: true));
    AddPrimaryKey("dbo.Item", "id");
    AddForeignKey("dbo.AddGallery", "item_fk_id", "dbo.Item", "id");
    AddForeignKey("dbo.ExtraFieldValue", "item_fk_id", "dbo.Item", "id");
    DropColumn("dbo.Item", "item_id");
}

public override void Down()
{
    AddColumn("dbo.Item", "item_id", c => c.Int(nullable: false, identity: true));
    DropForeignKey("dbo.ExtraFieldValue", "item_fk_id", "dbo.Item");
    DropForeignKey("dbo.AddGallery", "item_fk_id", "dbo.Item");
    DropPrimaryKey("dbo.Item");
    DropColumn("dbo.Item", "id");
    AddPrimaryKey("dbo.Item", "item_id");
    AddForeignKey("dbo.ExtraFieldValue", "item_fk_id", "dbo.Item", "id");
    AddForeignKey("dbo.AddGallery", "item_fk_id", "dbo.Item", "id");
}
1
4
10/9/2017 10:29:08 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I believe the primary key no longer exists and this is why it cannot be dropped.

2
5/25/2015 1:04:28 AM

Popular Answer

I find an solution for this problem. Because I've trying to change the name of the existing primary key name, I encountered an error while migration because that primary key was referenced to other tables. So the solution was simply to add [Column("id")] DataAnnotation and than make the migration. Column name of the primary key was successfully changed without any error.

Olrhain

Related Questions

Error loading type 'System.Data.Entity.Infrastructure.DbContextInfo' in EF Migrations

Try installing the msi....http://www.microsoft.com/download/en/details.aspx?id=26825...The second error that you are getting sounds like it s having problems identifying a context within your project. Make sure that you have a class that inherits from DbContext....I would also check that your project is referencing the correct version of the Entity...
code-first ef-migrations entity-framework
asked by Scott Munro

Entity Framework DbContext Connection string not seen in app.config/web.config

I had this issue when I was attempting to do an update-database command from the "package manger console". I had a separate project for my code first Data access layer and another for my web project, etc...I was using the following command: ..."update-database -projectname MYPROJECTDANAME -CONNECTIONSTRINGNAME CONNECTIONSTRING -Force"...so it point...
database-first dbcontext ef-code-first entity-framework
asked by user1619480

Entity Framework error - Error 11009: Property ' ' is not mapped

I had this issue when I changed a column name from ...CampaignKey... to ...CampaignCode.... After making the DB change, I went to the ....edmx... designer, right clicked and chose ...Update Model from Database.... Then when I compiled I got the error: ...Error 11009: Property ...CampaignKey... is not mapped. ...Taking a closer look at my table i...
c# entity-framework mapping visual-studio-2008
asked by tjp69

Unique Constraint with Entity Framework using Code First Migrations

Since EF 6.1 you can now do this in your model with either ...an attribute... [Index("IX_UniqueName", IsUnique = true)] public string Name {get;set;} ...or fluent...Property(s => s.Name).HasColumnAnnotation(IndexAnnotation.AnnotationName, new IndexAnnotation( new IndexAttribute("IX_UniqueName") { IsUnique = true })); ...The fluent meth...
asp.net-mvc-4 code-first ef-code-first entity-framework
asked by Not loved

Drop or Recreate database with Entity Framework Migrations (Code-First)

You can get the same behavior with Migrations by using automatic migrations....PM> enable-migrations -EnableAutomaticMigrations ...In Configuration.cs in the constructor, make sure automatic migrations and allow data loss are set to true......public Configuration() { AutomaticMigrationsEnabled = true; AutomaticMigrationDataLossAllowed = tru...
.net asp.net ef-migrations entity-framework
asked by Anthony Chu

Cannot drop the database 'DB', because it does not exist or you do not have permission

My bet is that you have ...AutomaticMigrationsEnabled... set to ...true..., otherwise your application wouldn't be trying to do anything with your database just because you pulled the latest version from TFS....Also, automatic migrations don't try to drop your database, not unless your have ...DropCreateDatabaseWhenModelChanges... or ...DropCreateD...
c# database entity-framework-6 visual-studio-2013
asked by André Pena

Entity Framework Migrations can't drop table because of foreign key constraint

If the ...dbo.Bingo_Bonus... table name has ever changed, or if any of the columns in the foreign key relationships have changed, EF does not rename the foreign key constraints automatically to match. I had a similar problem and I had to manually add a line like this because the ...DropForeignKey()... function was not actually deleting the key it ...
ef-migrations entity-framework
asked by Andy Raddatz

Database applies ALL previous migrations on update and NOT just the new one

One issue that can cause migrations to rerun is if your context key changes which can happen during refactoring. There are a couple of ways to solve this:...1) Update the old records in __MigrationHistory with the new values:...UPDATE [dbo].[__MigrationHistory] SET [ContextKey] = ‘New_Namespace.Migrations.Configuration’ WHERE [ContextKey] =...
database database-migration ef-migrations entity-framework entity-framework-6
asked by Steve Greene

'PK_dbo.EntityName' is not a constraint. Could not drop constraint.EF6

Having experienced a similar issue after renaming the table schema, I solved by explicitly delete the PK name with sql....In my case the issue arose when a primary key was changed in a table after renaming the table schema:...Original:...dbo.LogEntries with PK-name: PK_dbo.LogEntries...step 1: schema change:...Logging.LogEntries with PK unchanged..
code-first entity-framework-6
asked by Stefan

Would the Entity Framework's navigational properties work if I drop foreign key constraints from the database?

At this case better to remove references from both classes and handle relations manually outside of these classes:...public class Sims { public int ID { get; set; } public string Code { get; set; } //public User User { get; set; } public int UserID { get; set; } }
c# entity-framework entity-framework-6 sql
asked by Slava Utesinov

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow