Entity Framework - SaveChanges with GUID as EntityKey

Posted by MissingLinq on Stack Overflow See other posts from Stack Overflow or by MissingLinq
Published on 2010-05-13T13:37:41Z Indexed on 2010/05/13 14:34 UTC
Read the original article Hit count: 663

Filed under:
|

I have a SQL Server 2008 database table that uses uniqueidentifier as a primary key. On inserts, the key is generated on the database side using the newid() function.

This works fine with ADO.NET. But when I set up this table as an entity in an Entity Framework 4 model, there's a problem. I am able to query the entity just fine, but when creating a new entity and invoking SaveChanges() on the context, the generated uniqueidentifier on the database is all zeros.

I understand there was an issue with EF v1 where this scenario did not work, requiring creating the GUID on the client prior to calling SaveChanges. However, I had read in many places that they were planning to fix this in EF 4.

My question -- is this scenario (DB-side generation of uniqueidentifier) still not supported in EF4? Are we still stuck with generating the GUID on the client?

© Stack Overflow or respective owner

Related posts about entity-framework

Related posts about guid