Context version of Scope.GetSqlQuery?

[Garry]

I used to use scope.GetSqlQuery, but now that I am using the new context objects I can't seem to be able to run straight TSQL against OpenAccess. Am I missing something or is there context method similar to the old scope one? I know I can run stored procedures, but I really just need ot be able to pass in a TSQL query this time.

Thanks!

[Petko_I]

Hello Garry Clark,

Currently the functionality you require is not directly exposed through the new context. However, you can create a partial class which extends the generated Entity Diagrams context and expose the protected method GetScope() to retrieve an instance of the old scope.

public partial class NorthwindContextWithScope : NorthwindContext
{
    public IObjectScope GetInternalScope()
    {
        return this.GetScope();
    }
}

Here we assume that NorthwindContext is the generated class which extends OpenAccessContext. With the IObjectScope available you can make use of the GetSqlQuery method as well as some other functionality which you feel is missing.

Should you want to know something else, do not hesitate to contact us.

Kind regards,
Petko_I
the Telerik team