"A relationship is being added or deleted from an AssociationSet" Foreign Key Issue on Update

Question

I'm working with EF in a detached fashion because I'm using WCF services. I'm having trouble setting a foreign key reference when updating the entity (add works fine.)

The code - http://pastebin.com/d4f69895d

On db.SaveChanges() - it throws the exception - "A relationship is being added or deleted from an AssociationSet 'FK_Users_CarrierId'. With cardinality constraints, a corresponding 'Users' must also be added or deleted."

Here's how I add the carrier reference:

entity.CarrierReference.EntityKey =

new EntityKey("CouponEntities.Carrier", "CarrierId", user.Carrier.Id);

How do I fix this exception? Dealing with foreign keys seems to not be so much fun in EF...

Thanks,
Justin

Answer 1

: BUMP :

Answer 2

I think the answer is that EF just sucks right now. Switched back to Linq to SQL for the time being...

Answer 3

IS IT SUCKS YET?

I'm with the same problem. Indeed i'm with a lot of problem. Problems to update entity that as relashionship. Problem when send object to clients, when they come back the context forgot how is this entity.

Answer 4

I had the same problem. 

 http://stackoverflow.com/questions/1510902/problem-with-updating-entity-relation-using-stub-entities

In EF 3.5 SP1 you can't modify a reference without knowing the original value. 

Answer 5

I posted my frustration on the link below. For me EF is still sucks like our friend wrote above. My conclusion is, don't use it on your project it's too imature ORM framework. I'm using NHibernate and I'm much much happier.

http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/30eae05e-2e0f-4ad2-b577-34e22a4d5081