Using OQL with Visual Designer?

[King Wilder]

I have, maybe a dumb question.  If I create my model from the visual designer, is it still possible to use OQL?

The examples I see use the ObjectScopeContainer.

IObjectScope scope = ObjectScopeProvider1.GetNewObjectScope();
           string query = "SELECT * FROM OrderExtent AS o WHERE o.employee.employeeID=5";
           var result = scope.GetOqlQuery(query).Execute();
           foreach (Order ord in result)
           {
               Console.WriteLine(ord.OrderID);
           }

I would like to do something like this if possible:

using (var context = new MyEntitiesContext())
{
    string query = "SELECT * FROM OrderExtent AS o WHERE o.employee.employeeID=5";
    ??? Now what??  :^)
}

Is this possible?  If so, what is the syntax for this?

Thanks,

King Wilder

[Serge]

Hi King Wilder,

  What you have read is correct, we only support as part of the old OpenAccess API built around IObjectScope. However if you are willing to go one extra step you can use it with the new domain model, this is not something that is recommended but it is possible. In order to do so, you have to create a partial class to the domain model and in it expose the inner scope of the context. Your code should look a like this : 

public partial class YourContextNameHere
{
    public IObjectScope Scope
    {
        get
        {
            return this.GetScope();
        }
    }
}

This way you can use the scope as you would  normally do with older OpenAccess versions. Again this is not recommended and the scope is only exposed for backward compatibility reasons. 

Sincerely yours,
Serge
the Telerik team

[King Wilder]

Got it!  I created some examples in my application and it works perfectly. 

Thanks.

[Christian]

Hi,
OQL is (was?) a very good way to create queries at runtime. Is there an example with the domain model without a scope?
Thanks
Christian

[Jordan]

Hello Christian,

When working with an OpenAccess context usually LINQ is used in order to do queries.
If you want / need to compose queries dynamically you can either use

• dynamic LINQ as shown in this blog post:

http://blogs.telerik.com/blogs/posts/09-12-28/dynamic_query_with_telerik_openaccess.aspx

• or construct parts of the query using the .net expression api like in this forum post:

http://www.telerik.com/community/forums/orm/linq-questions/dynamic-criteria-problem.aspx

All the best,
Jordan
the Telerik team