C# ASP.NET Make Relation Between GUID[Primary Key] and Integer

Question

Im confuse how to make relation between GUID and Integer, i have to retrieve UserId data from CompanyID[Integer] as seen below images ::

This CompanyID Integer

This Id is a GUID type

I know INT and GUID is a different datatype, but how to make it relation[foreign key] ???

Basically what i need to do is I need to show specific data to user that have specific roles , i think this isthe only problem, make relation between this 2 different table.

u guys have any idea to solve this ? thank you

Answer 1

You can use either GUID or INT for foreign keys, but they both have to be the same type. You can't link a GUID to an INT.

You can either change one of the types, or add a new column with the same type.