I'd like to create this sql query
select * from xf_uziv u where not exists(select * from tf_project_members pm where u.ID = pm.XF_UZIV_ID)
I have this so far .I can't figure out the correct parameters order in the FieldCompareSetPredicate ctor.
var collection = new EntityCollection<XfUzivEntity>();
var filter = new RelationPredicateBucket();
filter.PredicateExpression.Add(
new FieldCompareSetPredicate(
TfProjectMembersFields.XfUzivId,
null,
XfUzivFields.Id,
null,
SetOperator.Exist,
null, true));
adapter.FetchEntityCollection(collection, filter);