Hi,

I've a XtraGrid with a lookupEdit, this column is a external key, when changed the value of lookupEdit and save the LINQ class throw this exception:

ForeignKeyReferenceAlreadyHasValueException

you help me place  

 Hello,

I'm not really sure - but I mean you must update the referenced Object and not the Key.

Please use the search function, because you are not the first with that questsion.

Markus

Ok,

But my problem is:

TabTest:

ID: int primary

ID_TabExternal : nvarchar(50)

TabExternal

ID_TabExternal : nvarchar(50) primary

Relation: (TabExternal (one) -> TabTest (many)

The exception is throw then changed ID_TabExternal in TabTest (the new value exists in TabExternal).

Sorry for my horrible English.

I have exactly the same problem. I also tried to update the referenced object, but instead of updating the child table and its foreign key with existing record in parent table, a new record was added to it.

Very strange. I now it has more to do with Linq rather then Devexpress components, stil I have no idea how to handle this, so I want ask here. And what I cant understand is that in many other projects I worked on, I could update my object by assigning a value to the foreign key without any problems, until now...

Please help...

Hi,

I've "resolved" the problem deleting the reference in the file dml between the two related entities (table).

Ciao

You mean deleting the relation or?!

Yes but also in the dml file not in the database

I solved it! Now it works. The problem was that I used different DataContext objects, and that's why it couldnt recognize existing object.