Getting "An entity with the same identity already exists in this EntitySet" but the EntitySet is empty

Question

When I try to add a new item to my EntitySet, I'm getting this exception:

An entity with the same identity already exists in this EntitySet

However, when I inspect the EntitySet its count is 0.

Any ideas why I would be getting this error when the set is empty? How could an entity already exist in the set if the set has no items in it?

UPDATE

I've narrowed this down a bit more. This is only happening if I add the item to the set, remove it, then re-add it. Even tho the item isn't in the EntitySet any more it is still remembering it somehow. What do I need to do to make it forget?

UPDATE: Here are some code snippets for the classes and logic involved.

Server Entities:

public class PhotoDto
{
    [Key]
    [Editable(false)]
    public int Id { get; set; }

    /* clip */

    [Include]
    [Association("Photo_Destination", "Id", "PhotoId")]
    public EntitySet<PhotoDestinationDto> Destinations { get; set; }
}

public class PhotoDestinationDto : BaseDestionationDto
{
    [Key]
    [Editable(false, AllowInitialValue = true)]
    public int PhotoId { get; set; }

    [Key]
    [Editable(false, AllowInitialValue = true)]
    public bool IsAnnotated { get; set; }

    [Key]
    [Editable(false, AllowInitialValue = true)]
    public int DropZoneId { get; set; }
}

public class BaseDestinationDto
{
    [Key]
    [Editable(false, AllowInitialValue = true)]
    public Guid DatabaseUid { get; set; }

    [Key]
    [Editable(false, AllowInitialValue = true)]
    public string Unit { get; set; }

    [Key]
    [Editable(false, AllowInitialValue = true)]
    public string EqCircId { get; set; }

    [Key]
    [Editable(false, AllowInitialValue = true)]
    public string EqType { get; set; }
}

Client side GetIdentity() for PhotoDestinationDto:

/// <summary>
/// Computes a value from the key fields that uniquely identifies this entity instance.
/// </summary>
/// <returns>An object instance that uniquely identifies this entity instance.</returns>
public override object GetIdentity()
{
    if ((((this._eqCircId == null) 
                || (this._eqType == null)) 
                || (this._unit == null)))
    {
        return null;
    }
    return EntityKey.Create(this._dropZoneId, this._eqCircId, this._eqType, this._isAnnotated, this._photoId, this._unit, this._databaseUid);
}

To remove photo destination client side:

PhotoDto photo = GetPhotoDto();
PhotoDestinationDto destToRemove = photo.Destinations.First(x => x.DropZoneId == 1);
photo.Destinations.Remove(destToRemove);

To add photo destination client side:

var dest = new PhotoDestinationDto
{
    DropZoneId = zoneId,
    EqCircId = selectedEqCircId,
    EqType = selectedEqType,
    Unit = selectedUnit,
    PhotoId = id,
    DatabaseUid = selectedDatabaseId
};

p.Destinations.Add(dest); // this is where exception is thrown. p.Destinations.Count is 0 here.

A shot in the dark: is the entity set missing the KeyAttribute ? — Timores
I have an [Association] attribute on the actual EntitySet<T> property. The T type that is in the EntitySet<> also has properties with [Key] attributes. — joshuapoehls

Simon_Weaver Simon_Weaver · Accepted Answer · 2010-07-25T05:16:05

Juding by your code Unit = selectedUnit and p.Destinations.Add(dest); and the other symptoms you describe you seem to have the exact same situation. My findings below have fixed the problem for me.

Interested also if you ended up with any duplicated entities in your database as a result of this. i was getting rows already previously saved magically turning to New and then becoming dupe records. Again this simple change below fixed it.

There is a race condition i discovered that can give this error if you create an entity and immediately assign foreign key relationships to it before adding the parent entity to its entity set.

Turns out the very act of setting the foreign key relationship actually adds the entity to its corresponding entity set - but sometimes causes a race condition, especially if your UI is loading and saving and clearing entity sets.

bad:

var todo = new TODO();
todo.Status = TODOContext.Statuses.Single(x=>x.Status == "Unknown");
todo.AssignedTo = TODOContext.Users.Single(x=>x.UserName == "JSMITH");
TODOContext.TODOs.Add(todo); // adding entity after setting FK

good:

var todo = new TODO();
TODOContext.TODOs.Add(todo); // add entity before setting FK
todo.Status = TODOContext.Statuses.Single(x=>x.Status == "Unknown");
todo.AssignedTo = TODOContext.Users.Single(x=>x.UserName == "JSMITH");

Getting "An entity with the same identity already exists in this EntitySet" but the EntitySet is empty

6 Answers