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

This Visual Studio 2010 RC bug is really causing grief. If you see the error message above, check your EDMX file. Visual Studio may have kindly inserted an extra

StoreGeneratedPattern="Identity"

into your EDMX file on a child table for the association back to the parent table.

For example, this …

        <EntityType Name="ExceptionRecordData">
          <Key>
            <PropertyRef Name="ExceptionDataUID" />
          </Key>
          <Property Name="ExceptionDataUID" Type="bigint" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="ExceptionUID" Type="bigint" Nullable="false" />
          <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="32" />
          <Property Name="Value" Type="nvarchar" Nullable="false" MaxLength="128" />
        </EntityType>

becomes this … after a simple Update operation

        <EntityType Name="ExceptionRecordData">
          <Key>
            <PropertyRef Name="ExceptionDataUID" />
          </Key>
          <Property Name="ExceptionDataUID" Type="bigint" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="ExceptionUID" Type="bigint" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="32" />
          <Property Name="Value" Type="nvarchar" Nullable="false" MaxLength="128" />
        </EntityType>

Note how it has added an extra StoreGeneratedPattern=”Identity” on the ExceptionUID property. I hope this gets fixed soon.

If you experience this problem, here’s the link to up-vote it:- https://connect.microsoft.com/data/feedback/details/540058

Update: Microsoft has confirmed that this will be fixed in the released version of Visual Studio 2010 – see comments. Thanks!

Tags: .NET, Entity Framework

#1 written by Craig Lee (MSFT)
about 1 year ago

I am sorry that this has been causing you grief. This has been fixed for VS 2010 RTM.
#2 written by Ian
about 1 year ago

Thanks Craig for following up, glad to hear it’s fixed!
#3 written by Daniel Simmons
about 1 year ago

This has been fixed for the final release of VS2010.

- Danny
#4 written by kumar
about 11 months ago

Is this bug valid for vs2008 sp1?
(Entity framework’s first version)
#5 written by Ian
about 11 months ago

@kumar, it was a bug introduced part way through the development of EF4 and fixed before it was released, so I don’t think it applies to EF1.
#6 written by Justin
about 8 months ago

It seems this issue still exists in 2010. Unless this is caused by another problem. I have the same hierarchy in my edmx
#7 written by Justin
about 8 months ago

I have a hierarchy setup like this

Person << Client (Client inherits from person). Person.PersonId (PK)
Client.ClientId (PK, FK to PersonId)

Whoever setup the database set the Client.ClientId to Identity=true. So please disregard my last comment.

No trackbacks yet.

Consultancy

about 11 months ago - No comments

Software Consultancy Serving the Greater Seattle Area Our consulting service is now open for business. We can help you with:- Business planning Program management Software Development for the Microsoft.NET platform Architectural advice and review Custom software development (offsite or onsite) Migrating web applications to ASP.NET MVC 2 Migration to Entity Framework 4 Complex threading using More >

Constrained parallelism for the Task Parallel Library

about 11 months ago - No comments

When developing .NET applications there is often the need to execute multiple background processes, for example, fetching and rendering different size thumbnails for images. Typically you queue actions like these onto the thread pool. But in the case of thumbnail generation you typically want to fetch a base image first and then perform the resize More >

Singleton tasks: A TaskFactory for the Task Parallel Library with ‘run-only-one’ semantics

about 11 months ago - No comments

When developing .NET applications there is often the need to execute some slow background process repeatedly. For example, fetching a feed from a remote site, updating a user’s last logged in time, … etc. Typically you queue actions like these onto the thread pool. But under load that becomes problematic as requests may be coming More >

GDI+ Image.FromFile has a problem – here’s how to fix it

about 1 year ago - No comments

In GDI+ you can call Image.FromFile to load an image from a file. BUT there are several issues with this call, the biggest being that GDI+ will keep the file open long after you are done with it. Here is an image loader that gets around this issue. If you are running a high volume More >

An ontology triple (quad) store for RDF/OWL using Entity Framework 4

about 1 year ago - 3 comments

This weeks side-project was the creation of an ontology store using Entity Framework 4. An ontology store stores axioms consisting of Subject, Predicate, Object which are usually serialized as RDF, OWL, N3, … Whereas there’s lots of details about these serialization formats, the actual mechanics of how to store and manipulate them was somewhat harder More >

The relationship could not be changed because one or more of the foreign-key properties is non-nullable

about 1 year ago - 1 comment

Today’s cryptic Entity Framework message … The operation failed: The relationship could not be changed because one or more of the foreign-key properties is non-nullable. When a change is made to a relationship, the related foreign-key property is set to a null value. If the foreign-key does not support null values, a new relationship must More >

Error 3032: Problem in mapping fragments : mapped to the same rows in table

about 1 year ago - 2 comments

Today I tried creating a two-level hierarchy using Entity Framework 4 but using the same discriminator column for both layers of the hierarchy. It seems you cannot do this but instead must have a separate column for each layer of the hierarchy. Makes some sense but the error message wasn’t very helpful. I have a More >

A simple redirect route handler for ASP.NET 3.5 routing

about 1 year ago - 2 comments

ASP.NET 3.5 Routing is a very powerful tool not just for registering routes for newer ASP.NET MVC applications but also for adding SEO friendly routes to older Webforms (ASPX) applications, or for routing multiple URLs to a single page. But that’s not all it can do. You can create your own IRouteHandler and then have More >

Why functional programming and LINQ is often better than procedural code

about 1 year ago - No comments

Functional programming is a relatively new component in the C# language. It can potentially replace for-loops in many situations with simpler code, but the question remains ‘what’s wrong with a good old for loop?’ Here are some of the reasons I think functional programming is important and in particular how LINQ can improve the readability, More >

Using Home Automation to Monitor Cable Modem

about 1 year ago - 2 comments

Some time ago I was having an issue with my cable modem connection. The connection was intermittent at certain times of day but fine otherwise. Calling the cable company with an intermittent problem is pointless: you get the standard answer “But it’s working fine now”. So, since I have the world’s smartest home automation system More >

Jun	AUG	Feb
	09
2010	2011	2014

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

No trackbacks yet.

Consultancy

Constrained parallelism for the Task Parallel Library

Singleton tasks: A TaskFactory for the Task Parallel Library with ‘run-only-one’ semantics

GDI+ Image.FromFile has a problem – here’s how to fix it

An ontology triple (quad) store for RDF/OWL using Entity Framework 4

The relationship could not be changed because one or more of the foreign-key properties is non-nullable

Error 3032: Problem in mapping fragments : mapped to the same rows in table

A simple redirect route handler for ASP.NET 3.5 routing

Why functional programming and LINQ is often better than procedural code

Using Home Automation to Monitor Cable Modem

Recent Posts

My latest tweets