Column names in each table must be unique. Column name 'StripeRecipientId' in table 'dbo.Foos' is specified more than once

code-first entity-framework entity-framework-6

Question

I have a model class named Foo that has, among others, these properties.

public string StripeRecipientId { get; set; }

public override bool HasProvidedBillingInformation
{
    get
    {
        // return !string.IsNullOrEmpty(this.StripeRecipientId);

        return false;
    }
}

I have enabled migrations and am using Code First. When I run the update-database commandlet, whether with -Force option is specified or not, I get this error:

Column names in each table must be unique. Column name 'StripeRecipientId' in table 'dbo.Foos' is specified more than once.

I double-checked and triple checked and there's only one column of that name in my model as well as in the table. This column was created already by a previous run of the update-database commandlet just a while ago.

I am tempted to delete my database and then apply the migrations, but that will mean me having to create a lot of test data just to be able to test the feature I am working on just now.

I am using Entity Framework v6.1.2.

How do I get rid of this error?

1
11
9/29/2015 1:31:15 PM

Accepted Answer

Run the Add-Migration command with the -IgnoreChanges flag. Then run Update-Database again.

-Update-

These commands should be run in the Package Manager Console. From the main menu: Tools-> NuGet Package Manager -> Package Manager Console.

20
12/23/2016 8:38:00 AM

Popular Answer

This worked for me.

  1. I run this Add-Migration -IgnoreChanges and i got error that your previous two migrations are in pending. Example: Migration-1 , Migration-2

  2. I run update-database -target Migration-1 and

    update-database -target Migration-2

  3. Database Successfully created. Running Seed method.



Related Questions





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