Archive for February 18th, 2011

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

February 18, 2011

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: .
  • February 2011
    M T W T F S S
    « Jan   Mar »
     123456
    78910111213
    14151617181920
    21222324252627
    28  
  • .

    .Net Agile Antivirus Book C# Programming EntityFramework GTD Hyper-V LinQ MVVM Office Resharper SCRUM Security Sharepoint Silverlight SQLServer TFS ToDoList Unit Test VirtualBox Virtual PC Visual Studio VMware Windows7 WPF XeDotNet XML XPath

  • Follow

    Get every new post delivered to your Inbox.