Creating an exist clause

Posts   
 
    
methodman
User
Posts: 194
Joined: 24-Aug-2009
# Posted on: 22-Feb-2011 23:35:58   

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);
daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 23-Feb-2011 06:35:37   

It's in the docs. Try this:

bucket.PredicateExpression.Add(new FieldCompareSetPredicate(
    XfUzivFields.Id, null, TfProjectMembersFields.XfUzivId, null,
    SetOperator.Exist, (XfUzivFields.Id == TfProjectMembersFields.XfUzivId)));
David Elizondo | LLBLGen Support Team
methodman
User
Posts: 194
Joined: 24-Aug-2009
# Posted on: 23-Feb-2011 09:02:40   

Solved, thanks..