EF Core3 : One to one relation multiplicity wrong

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
mrmiagi0101
Posts: 23
Joined: Tue 27 Feb 2018 13:43

EF Core3 : One to one relation multiplicity wrong

Post by mrmiagi0101 » Thu 25 Nov 2021 16:49

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?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: EF Core3 : One to one relation multiplicity wrong

Post by Shalex » Fri 26 Nov 2021 16:26

Thank you for your request. We will investigate the question and notify you about the result.

mrmiagi0101
Posts: 23
Joined: Tue 27 Feb 2018 13:43

Re: EF Core3 : One to one relation multiplicity wrong

Post by mrmiagi0101 » Fri 07 Oct 2022 13:03

Any update?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: EF Core3 : One to one relation multiplicity wrong

Post by Shalex » Fri 07 Oct 2022 15:41

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.

Post Reply