GUID as foreign key

Chan — Tue, 06 Feb 2007 09:00:25 GMT

Hi,
I am using GUID as PK in master table. I have another table which is 1-many relationship. When I save my child table, it hit error as below. Any ideas?

I have set mastertable.PK and childtable.FK as GUID in BO mapper.

Please advice.



--Conversion failed when converting from a character string to uniqueidentifier.



exec sp_executesql N'INSERT INTO [dbo].[Books] ([ItemID], [PublisherID], [LanguageID], [PaperTypeID]) VALUES (@ItemID, @PublisherID, @LanguageID, @PaperTypeID);

',N'@ItemID uniqueidentifier,@PublisherID uniqueidentifier,@LanguageID int,@PaperTypeID 

int',@ItemID='264FA570-8942-4FD2-BF3D-590D9F7C2464',@PublisherID='494AE887-A731-42A9-8890-10AA147FAECD',@LanguageID=0,@PaperTypeID=0

RE: GUID as foreign key

StrataFrame Team — Tue, 06 Feb 2007 09:00:25 GMT

I'm not sure about the conversion from NChar types to UIDs, you will most likely have to use either a CAST or a CONVERT to change the string to a GUID. You'll need to check the SQL Server Books Online for the version of SQL Server you're using to see how to convert the string to a GUID.

StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » GUID as foreign key

GUID as foreign key

RE: GUID as foreign key