Relationship between tables 1:1

[wlandgraf (Wagner Landgraf)]

Hi @Wesley_Bobato, welcome to our Support Center.

If the foreign key field in database is in Script table, then there is where you should add your mapping. It's as simple as that.

A one-to-one relationship is simply a normal many-valued association relationship where you can only have a maximum of one item in the list. Thus, you should map as a regular many-valued association.

This topic explains how you can create a one-to-one relationship at the class Delphi:

How to map one-to-one association

You should always map a one-to-many, and then you can add wrappers to make your object behave as 1-1 at OOP-level: TPerson = class private [ManyValuedAssociation([TAssociationProp.Lazy], CascadeTypeAll)] FAddresses: Proxy<TList<TAddress>>; public property Address: TAddress read GetAddress write SetAddress; end; function TPerson.GetAddress: TAddress; begin if FAddresses.Value.Count > 0 then Result := FAddresses.Value[0] else Result := nil; end; procedure TPerson.SetAddres…

I'm moving this topic to TMS Aurelius category.