Creating foreign key relations to ASP.NET Users uniqueidentifer field
Posted on 2010-09-10
Im sure there is a simple answer to this, but its not something Ive come across before and im a little bit unsure as to how to proceed.
I have a small number of users as part of an admin site that are created and managed by ASP.NET's membership provdier. As such they have been created in SQL Server with the UniqueIdentifier data fields as their identifying ID.
I have several other tables that I need to create a foriegn key relationship to the user the record relates to. usually id just be dealing with Integer values, but what datatype should the foreign key field be? Do I really need to store the uniqueidentifer value in every foreign key record?