Databases
StackOverflow2013
Postsdbo
POEF 4.0 UpdateException
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEF 4.0 UpdateException
    primarykey
    data
    text
    <p>I'm using EF 4.0 within VS 2010 RC. I have pretty simple POCO class structure with few dependencies. Each POCO class has a base generic class (EntityObject or ValueObect) with property ID. I have several CRUD tests and only one of them works. This one is very simple where object does not have any dependencies. But when I test something with FK dependencies I always get the same error: System.Data.UpdateException: A value shared across entities or associations is generated in more than one location. Check that mapping does not split an EntityKey to multiple store-generated columns. I've googled that but the only reason of this exception that I found is usage of several contextes which is not my case. </p> <pre><code> using (IEntityModelContext context = new EFDataContext()) { var licTypeFact = context.GetFactory&lt;LicenceType&gt;(); var metaValFact = context.GetFactory&lt;MetaValue&gt;(); var cultSpecFact = context.GetFactory&lt;CultureSpecificValue&gt;(); LicenceType licType = licTypeFact.CreateObject(); Assert.IsNotNull(licType); Assert.IsTrue(licType.IsTransient); licType.AdvancedFeatureSet = true; licType.BasicFeatureSet = true; licType.MaxUsers = 10; licType.MonthDuration = 1; MetaValue licTypeName = metaValFact.CreateObject(); licTypeName.Name = "TestLicType"; CultureSpecificValue licNameEng = cultSpecFact.CreateObject(); licNameEng.Value = "Test Licence"; licNameEng.Culture = context.CultureRepository.Load(cult =&gt; cult.Name == "Eng"); licNameEng.MetaValue = licTypeName; licTypeName.CultureSpecificValues = new List&lt;CultureSpecificValue&gt;(); licTypeName.CultureSpecificValues.Add(licNameEng); licType.Name = licTypeName; licType.NumberOfQuestionsPerSurvey = 1; licType.NumberOfResponsesPerSurvey = 2; licType.NumberOfSurveys = 3; licType.PerUserPrice = 10; licType.Price = 100; context.LicenceTypeRepository.Add(licType); int res = context.SaveChanges(); </code></pre> <p>So what can be the reason of this exception?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJoel Coehoorn
    1. USVoice
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POEF 4.0 UpdateException
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POEF 4.0 UpdateException
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThere's a lot of custom code you're not showing here, and I strongly suspect the error is there. I'd suggest removing the layers of indirection and just using the context. The error will go away. Then add the indirection back until the error reappears.
      singulars
      1. POEF 4.0 UpdateException
      1. USCraig Stuntz
    2. COThanx Craig. I regenerated edmx and this problem has gone.
      singulars
      1. POEF 4.0 UpdateException
      1. USVoice
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload