DevExpress Free joins (No foreign key)

Date: 2026-02-06

https://docs.devexpress.com/CoreLibraries/8130/devexpress-data-library/free-joins

https://supportcenter.devexpress.com/ticket/details/q508526/association-without-fk-or-calculated-property-with-free-join-in-xpo


CriteriaOperator criteria = 
    CriteriaOperator.Parse("[<Orders>][^.EmployeeID = EmployeeID].Count() > 50");
XPCollection<Employee> employees = new XPCollection<Employee>(session, criteria);


[PersistentAlias("[<First>][SomeUniqueNumber=^.TheSameUniqueNumber].Max(NameOfFirstObject)")]  
public string MyRelatedFirstObjectName { get { return Convert.ToString(EvaluateAlias("MyRelatedFirstObjectName")); } } 

100590cookie-checkDevExpress Free joins (No foreign key)