Telerik DataAccess and Oracle - Bind Variables

Thread is closed for posting
4 posts, 0 answers
  1. Martin
    Martin avatar
    3 posts
    Member since:
    Mar 2017

    Posted 17 Mar 2017 Link to this post

    Hi there,

     

    i've got a question around the data access component. Is there a way that OpenAccess can use bind variables for accessing data? We've got an OData-Facade which goes through Telerik.DataAccess and the dynamic sql requests against the database are going to the roof. 

    I've looked into our App and recognized that every query against the database is run with a new dynamic statement. The mapping of the data is done with the fluent context model.

     

    Beste Regards,

    Martin

  2. Viktor Zhivkov
    Admin
    Viktor Zhivkov avatar
    323 posts

    Posted 22 Mar 2017 Link to this post

    Hello Martin,

    If you are referring to the process of preparing statements before execution and reuse of the already prepared statement, please check if your RuntimeConfiguration.PrepareCommands configuration flag is set to true.

    Regards,
    Viktor Zhivkov
    Telerik by Progress
     
    Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
  3. Martin
    Martin avatar
    3 posts
    Member since:
    Mar 2017

    Posted 23 Mar 2017 in reply to Viktor Zhivkov Link to this post

    Hi Viktor,

     

    the PrepareCommands is set to true. By now i think that the problem isn't in telerik but in the odata implementation from microsoft. I will dig deeper in the future.

    Thanks for your help.

     

    Regards,

    Martin

  4. Martin
    Martin avatar
    3 posts
    Member since:
    Mar 2017

    Posted 23 Mar 2017 in reply to Martin Link to this post

    Hi,

    the problem seems to be, that the OData-Query from the url is translated into a linq expression. In this step the binding variables get missing.

    Beste Regards,

    Martin

Back to Top