Using a GUID as a Primary Key issues
Posted: Tue 14 Jun 2011 14:03
Hi,
We are using a GUID as a primary key (mobile centric app -- can't use sequence) and there are some quirks.
When retrieving data using EF it will return the values you are looking for including any related data (using Foreign Keys that are also GUIDs) but all of the GUID values that are primary keys have a GUID that did not come from the database. They seem to be newly generated GUIDs.
The model I am using does not have any GUID columns that are not used as either a Foreign Key or Primary Key so I do not know if the problem is with hydrating all GUIDs or just ones used in a Key.
Let me know what additional information you need.
This one is REALLY critical to us so I would appreciate a quick turnaround. I don't even mind testing a quick dev fix/patch!!
This was tested on 6.30.165.0
John.
We are using a GUID as a primary key (mobile centric app -- can't use sequence) and there are some quirks.
When retrieving data using EF it will return the values you are looking for including any related data (using Foreign Keys that are also GUIDs) but all of the GUID values that are primary keys have a GUID that did not come from the database. They seem to be newly generated GUIDs.
The model I am using does not have any GUID columns that are not used as either a Foreign Key or Primary Key so I do not know if the problem is with hydrating all GUIDs or just ones used in a Key.
Let me know what additional information you need.
This one is REALLY critical to us so I would appreciate a quick turnaround. I don't even mind testing a quick dev fix/patch!!
This was tested on 6.30.165.0
John.