Page 1 of 1

EF Core3 : One to one relation multiplicity wrong

Posted: Thu 25 Nov 2021 16:49
by mrmiagi0101
Hello,

I don't understand yor multiplicity in EF Core for one to one relations. For me it looks like they are on the wrong end in the designer. We are using ED 6.12.1354 with MS SQL Database.

We have two Tables 'WithTwoKeyFields' and 'RequiredOneToOne' table.
WithTwoKeyFields table is the principial of the relation and has just two columns as PK:
Image

'RequiredOneToOne' table has its own primary key and the two not nullable FK columns referencing to the PK columns of the WithTwoKeyFields table:
Image

So, a WithTwoKeyField row can have 0..1 RequiredOneToOne rows referenced.
A RequiredOneToOne always needs/has 1 WithTwoKeyField referenced.

So UML Multiplicity is WithTwoKeyField 1..1 -------> 0..1 RequiredOneToOne.

But the Designer shows it the other way around! This seems wrong to me:
Image

Can you explain this?

Re: EF Core3 : One to one relation multiplicity wrong

Posted: Fri 26 Nov 2021 16:26
by Shalex
Thank you for your request. We will investigate the question and notify you about the result.

Re: EF Core3 : One to one relation multiplicity wrong

Posted: Fri 07 Oct 2022 13:03
by mrmiagi0101
Any update?

Re: EF Core3 : One to one relation multiplicity wrong

Posted: Fri 07 Oct 2022 15:41
by Shalex
Thank you for bringing our attention to this request. As of right now, it is hard to provide any possible time frames.
On the other hand, please rest assured that as soon as we have any update on the process we'll let you know immediately.