Just for example:
refactoring some stored procedures, in order to get a simpler store procedure mapping,
combining ADD and UPDATE stored procedures in just one sp.
Field ID (int, identity(1,1)) as input parameter, and RETURN value, different by scopes: RETURN value only in ADD mapping,
both ADD ad UPDATE having ID as input parameter.
First tests failed, with this message: “Unable to determine a valid ordering for dependent operations. Dependencies may exist due to foreign key constraints, model requirements or store generated values.” .
Removing ID returned value in ADD action cleared the message, but it was necessary to auto-generate ID. :(
Technorati Tags: Entity Framework.