Data Relations using GUID (uniqueidentifier)

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

I am trying to build a data relationship between two tables in a dataset. I
am making the join on fields that are both System.Guid types in .NET and
uniqueidentifiers in SQL Server 2000. The join works as expected when used
in an SQL query but I get an empty set when I use the join in my dataset.

The join was working correctly when we were using integers as the primary
key but after changing the data types to GUIDs I am not able to make the
join.

Has anyone else experienced this kind of problem.

Thanks,
Andrew
 
Back
Top