CODEWITHSUNDEEP
c#.netentity-framework
Raheel Khan
Raheel Khan

Reputation: 14787

One to many relationship in Entity Framework 6

I have two simple tables that have to map to columns in an existing database:

public class StockItem
{
    public System.Guid pkStockItemID { get; set; }

    public virtual List<StockItem_ExtendedProperties> ExtendedProperties { get; set; }
}

public class StockItem_ExtendedProperties
{
    public System.Guid pkStockItem_ExtendedPropertiesID { get; set; }

    public System.Guid fkStockItemId { get; set; }

    public virtual StockItem StockItem { get; set; }
}

Following are the configuration classes for both:

public StockItemConfiguration ()
{
    this.HasMany(item => item.ExtendedProperties)
        .WithRequired(property => property.StockItem)
        .HasForeignKey(property => property.fkStockItemId)
        .WillCascadeOnDelete();
}

public StockItem_ExtendedPropertiesConfiguration ()
{
    this.HasRequired(property => property.StockItem)
        .WithMany(item => item.ExtendedProperties)
        .HasForeignKey(property => property.fkStockItemId)
        .WillCascadeOnDelete();
}

This results in the error: The item with identity 'StockItem_ExtendedProperties' already exists in the metadata collection. Parameter name: item.

It appears that defining the relationship from both sides of the table is causing the error. However, removing the configuration from either side still results in the same error.

In addition to how to fix the above, I'd like to know what the reason is and which of the two tables in such a relationship should be configured. Thanks.

Upvotes: 6

Views: 6037

Answers (4)

EyeSirvived
EyeSirvived

Reputation: 141

I tried removing the underscore but that didn't work for me. It turned out that in my case defining a (model)class in plural (+s) messed it up. After removing the s it worked again. Very weird but it solved it.

Using EF 6.0.0.0

Upvotes: 0

user3829854
user3829854

Reputation: 235

Removing the underscore solved my problem as well. However the real issue was the naming convention.

Renaming the navigation collection property on the one side of the relationship solved the problem without having to change the table name in the database

Upvotes: 1

cgonzalezr
cgonzalezr

Reputation: 71

I have that exactly problem too. A class named 'Paquete_PartNumber' throws the same error. Removing the underscore solves the issue.

Using EF 6.0.1.

Upvotes: 6

Raheel Khan
Raheel Khan

Reputation: 14787

Turns out the problem was the underscore in the entity name StockItem_ExtendedProperties. Removing that got rid of the error. Using EF 6.0.0.0 which was the latest available version via NuGet.

Upvotes: 10

Related Questions