.NET
Microsoft Technologies based on the .NET software framework.
3,415 questions
EF6 Designer relationship with two tables where only one key matches
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 48%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVF%3C/text%3E%3C/svg%3E)
Vasco Ferreira
1
Reputation point
Hello,
I am trying to match two tables with a column in common which is of type Guid, however in one of them that column is not key ( which i could change ) but in the other table i also have another key that has no match with the first table. So when i try to associate the two, if i pick the first as the main table it does not show the column i want and if i pick the second i get left with an extra column that i can't match.
Is there a way to accomplish what i am trying to do?
Best regards,
Vasco.
.NET
Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
1,403 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 90%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZL%3C/text%3E%3C/svg%3E)
Zhi Lv - MSFT 32,021 Reputation points Microsoft Vendor2021-09-27T01:32:00.807+00:00 Hi @Vasco Reina ,
Can you post the relate table structure and its related columns, and tell us which column is the Guid column and the foreign key? It is easier to understand what you want and help you fix the problem.
Besides, when using EF core/ EF to configure the relationship between tables, we could use the navigation property, and use the ForeignKey attribute or HasForeignKey method to set the foreign key. You can refer the following articles:
Sign in to comment