Create an outer join between entities

BIZ TMS Aurelius
1

I'd like to retrieve a list of objects that contain objects from two entities without using inheritance. The list would be an outer join between the two entities. Consider

[Entity, Automapping]
TEmployee = class
private
FId: Integer;
FName: string;
public
property Id: Integer read FId write FId;
property Name: string read FName write FName;
end;

[Entity, Automapping]
TerminatedEmployee = class
private
FEmployee: TEmployee;
FTerminationDate: TDate;
public
property Employee: TEmployee read FEmployee write FEmployee;
property TerminationDate: TDate read FTerminationDate write FTerminationDate;
end;

TEmployee has many objects. TTerminatedEmployee has a few. How do I create an outer join between the two using TObjectManager?

2

For clarity, I want to create in Aurelius the equivalent of the following:

select a.id, a.Name, b.TerminationDate from Employee a left join TerminatedEmployee b on a.Id = b.employee;

I'd also like to do

select id, Name from Employee where id not in (select id from TerminatedEmployee)

3

I assume you have an unique key in TerminatedEmployee that makes sure Employee_ID column there is unique, so you have a 1:1 mapping.

In this case I suggest you use this approach for 1:1 mapping:

4

After I made the post, I considered the solution you recommended. Thanks.