CODEWITHSUNDEEP
c#.netentity-framework-4
gruber
gruber

Reputation: 29789

circular dependency in entity framework

Is it possible to save model which has got circular dependency ?

I denormalized my Database:


User
--------
UserId
UserName
LastOrder   - fk to last order


Order
-------
OrderId
OrderName
UserId
OrderDate

Is it possible to save sth like this using entityFramework?

what should I change to make it work cause now I have got error:

Unable to determine a valid ordering for dependent operations. Dependencies may exist due to foreign key constraints, model requirements, or store-generated values.

Upvotes: 18

Views: 20879

Answers (1)

tkerwood
tkerwood

Reputation: 1905

I had a table that had a relationship to itself and i was getting the same error. Turns out the foreign key has to be nullable. Same table relationship in Entity Framework I hope this saves someone more time than I wasted.

Upvotes: 49

Related Questions