tags:

views:

43

answers:

1
Q: 

Entity Framework 4 Primary Key as GUID and autogeneration

I'm trying to use EF4 and the supposedly new feature of having GUIDs generated server side. I have a table with a GUID primary key and its default value is set to NewID() in SQL Server. However, I have tried setting StoreGeneratedPattern to Identity and Computer and neither works. I found this link on MSDN, with conflicting information. Some say it should work, some don't.

http://social.msdn.microsoft.com/Forums/en/adonetefx/thread/72f0045d-1619-4044-bf50-c6eb5091995e

Can anyone confirm if this should or should not work?

A: 

It does work in 4.0 if you set StoreGeneratedPattern. It does not work in 3.5. The "inefficient indexing" comment is only true if you have a clustered index on the GUID PK. It's false if your clustered index is elsewhere.

Craig Stuntz  2010-06-18 12:11:54
So should you set StoreGeneratedPattern to Computed or Identity? Still no luck, works fine on Identity Int and BigInt fields, but draws a blank on any UniqueIdentifier fields.
AKoran  2010-06-18 15:07:42
Identity. Did you change the SSDL? See this post: http://leedumond.com/blog/using-a-guid-as-an-entitykey-in-entity-framework-4/
Craig Stuntz  2010-06-18 15:17:39
Yes, I see, so in effect it doesn't really work using only the designer. The other downside is you have to always remember to put the StoreGeneratedPattern back in after refreshing the model from the DB. Not the most excellent solution! However, neither of those are your fault. Thank you for pointing me in the correct direction.
AKoran  2010-06-18 17:19:14

related questions

SQL tracing LINQ to Entities
SQL Anywhere 11 (Sybase) with Entity Framework in Visual Studio SP1?
ADO.NET Entity Framework and identity columns
Is anyone using Entity Framework with an Oracle database?
LINQ to entities - Building where clauses to test collections within a many to many relationship.
Entity Framework: how to return a base type from L2E
Unit Testing in .NET: How to Mock Entity Data Provider
Entity Framework - Can you map the result type of an imported stored procedure to a custom entity type?
Entity Framework and Application Architecture (loose coupling, etc)
Can you use Microsoft Entity Framework with Oracle?
Using MySQL with Entity Framework
How to Implement Database Independence with Entity Framework
What is the best data access paradigm for scalability?
ADO.NET Entity Framework tutorials
How do you create a database from an EDM?
Anyone using the Entity Framework *Well*?
What real-world usages of ADO.NET Entity Framework do you know?
Which ORM framework can best handle an MVCC database design?
Where to start with Entity Framework
How to customize Entity Framework classes?
Linq to Entities vs ESQL
ADO.NET Entity vs NHibernate
Update database schema in Entity Framework
Expression.Invoke in Entity Framework?
Entity Framework vs LINQ to SQL