Is there any possibility to join entities that do not know each other by associations? Something like this: TObjectManager.Find.CreateAlias(TEntity2, 'b').Join(Linq['Id'].Eq('b.field').

No need, associations (and many-valued associations) in dynamic properties are now supported in version 5.13: https://doc.tmssoftware.com/biz/aurelius/about/whats-new.html#version-513-january-2023

Using ObjectManager.Find to Join Entities

BIZ TMS Aurelius

Silber_Felix (Silber Felix) January 11, 2023, 4:54pm 5

Yeah, I have to fetch some columns of the other Entity.

And because there are more than 1 column an subselect within a projection is also not the best idea...

Topic		Replies	Views
Outer join for table B on table A where there is no constraint between the two tables TMS Aurelius	8	185	July 18, 2023
New Property FullAssociationName for TAureliusEntityDictionary BIZ Feature Requests aurelius	9	285	July 27, 2023
Lost in joins TMS Aurelius	2	381	June 21, 2023
Filter depending on association TMS Aurelius	2	450	February 12, 2020
how to join 2 tables via Aurelius TMS WEB Core	6	1163	March 16, 2021

Using ObjectManager.Find to Join Entities

Related topics