Telerik DataAccess and Oracle - Bind Variables

[Martin]

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

[Viktor Zhivkov]

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

 

[Martin]

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

[Martin]

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