I am stuck in a hole I didn't dig myself in: we have a flat import table($B) that eventually maps onto different tables and it can have duplicated IDs so no PK can be set. The issue is that this table gets used in an outer join with a crucial table ($A) of the system and thus I need some way to make Aurelius do so automatically.
I'd rather not load $B independently and recombine with $A which so far I am assuming is the only solution.
Because it's in an outer join, I am assuming I can define "fake FKs" and Aurelius should pick them up but I am not sure.
Can anyone please confirm that if I create "fake FKs" Aurelius will merrily make an outer join? (Yes, the matching property is going to be a Nullable<TList<$B>>).