Bug #45209 Entity Framework missing support for Guid

• Submitted: 30 May 2009 19:24
• Modified: 2 Jun 2009 18:09
• Reporter: Muhammad Mosa
• Status: Duplicate
• Category: Connector / NET
• Severity: S2 (Serious)
• Version: 6.0.3
• OS: Any
• CPU Architecture: Any
• Tags: entity framework

[30 May 2009 19:24] Muhammad Mosa

Description:
I am not able to map Entity Type's property of type Guid to any column in SSDL

How to repeat:
*Generate Entity Model from a database that has table contains field of type binary(16).

*When mapping is done, the EDM will not validate because of in correct mapping.

*Try to edit SSDL to specify different column type on Guid column like this:
<Property Name="Id" Type="guid" Nullable="false" />

You'll get Entity Model validation error as guid is not supported.

Suggested fix:
I was able to bypass this issue when I modified the ProviderManifest.xml
<Type Name="guid" PrimitiveTypeKind="Guid" ></Type>
just before "set" type definition.

[2 Jun 2009 18:09] Reggie Burnett

This is a duplicate of bug #44986 which has already been fixed