[Solved] Getting an Object based on an OQL Query

[sitefinitysteve]

WIth the Designer Context Method, I want to Query OA and return a single object back to the WF designer to play around with

public class OASingleObjectOQL<TResult> : NativeActivity<TResult> where TResult : class
{
    [RequiredArgument]
    [Category("InArgs")]
    public InArgument<string> OQLQuery { get; set; }

    public OASingleObjectOQL()
    {
        this.Constraints.Add(ConstraintHelper.VerifyParentIsObjectContextScope(this));
    }

    protected override void Execute(NativeActivityContext context)
    {
        OAObjectContext oaObjectContext = context.Properties.Find(OAObjectContext.ObjectContextPropertyName) as OAObjectContext;
        if (oaObjectContext == null)
        {
            throw new ValidationException("OpenAccess Object Context not found");
        }


        var output = ""; //QUERY CODE...?

        // set the result value
        this.Result.Set(context, output);
    }
}

I don't see any OQL query methods in my context....

Or is there a more efficient way to return a single object?...I'd try a Predicate, but I'm not sure of the VB style syntax to do that in the WF4 designer

[Jordan]

Hello Steve,

OQL is not supported by the context, generated by the visual designer.
You could however, use Dynamic Linq together with the GetAll<T> method of the context (in order to get an IQueryable instance).

I hope this helps. Do not hesitate to write again if you have more questions.

All the best,
Jordan
the Telerik team