Currently, the scenarios with database functions in Oracle are not fully supported on our side and the improvements are already in our TODO list.
For the time being, I would suggest that you try the following workaround:
1) Add the function to a package
in order for it to appear under the Stored Procedures and Functions node in the Choose Database Items dialogue
2) Update the model with the function
3) Extend the context class in a partial class and place the method for the function there. The database functions are executed with the ExecuteQuery<T>()
method of the context. Note that the sqlQueryString
for calling functions in Oracle would be:
For your convenience, I have prepared a small sample project that illustrates the workaround. Please kindly find it attached to this message.
Since the creation of the actual method strongly depends on the function itself, do not hesitate to get back to us, if you experience any difficulties with that.
the Telerik team