ED5 and use of GUIDs as Primary Keys??

[EdB]

(Reposted from EF Support as wrong forum)

Hi All,

New to Entity Developer 5(ED5), so hi.

I am just trying to setup a GUID for a primary key for a table which auto populates on the server (Entity Framework 5/ SQL Server 2008 R2). I tried setting the "Store Generated" value to "Identity", but no joy. It seems ED5 only wants a type of INT for sequential key autogeneration.

Is GUID Key autogeneration possible? If so how does one define it in ED5?

Thanks,

Ed

[Shalex]

Is GUID Key autogeneration possible? If so how does one define it in ED5?

Do you mean the Generate Database Script/Update Database From Model functionality in Entity Developer for GUID "Store Generated Pattern=Identity" properties (like a suggestion for EDM Wizard at http://entityframework.codeplex.com/workitem/551)?

[EdB]

Hi,

Thanks for the reply.

I guess so. Basically I need to be able to specify a GUID ID that will be automatically created on insertion of record, preferably at DB level so if I use SQL Manager to insert a record then I still get a new GUID, like how an INT ID with the IDENTITY attribute set works.

Ed

[Shalex]

We are investigating the possibility of implementing this functionality.

[EdB]

Thanks...

[Shalex]

The behaviour is changed: Generate Database Script/Update Database From Model wizards generate column with the default value NEWSEQUENTIALID() for Guid property with 'Store Generated Pattern=Identity'. We will post here when the corresponding build of Entity Developer is available for download.

[EdB]

Thanks, really appreciated.

Ed

[Shalex]

New build of Entity Developer 5.0.43 is available!
It can be downloaded from http://www.devart.com/entitydeveloper/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=32&t=25825.

[EdB]

Thanks, appreciated.