Default values for parameters of SP methods.
Posted: Tue 19 Aug 2014 10:15
Hi,
I am using VB.NET and PostgreSQL. When I add an SP to my model as a method, is there a way that the parameters of this method be given default values? Or is there a way to have nullable values have their default value set to Nothing?
Right now, as far as I'm aware, if I call a method on my context object I have to specify each parameter as Nothing, rather than the parameters being Nothing unless specified otherwise (and therefore falling back to the default value set in the SP).
Is there a way to achieve this?
Many thanks,
Peter
I am using VB.NET and PostgreSQL. When I add an SP to my model as a method, is there a way that the parameters of this method be given default values? Or is there a way to have nullable values have their default value set to Nothing?
Right now, as far as I'm aware, if I call a method on my context object I have to specify each parameter as Nothing, rather than the parameters being Nothing unless specified otherwise (and therefore falling back to the default value set in the SP).
Is there a way to achieve this?
Many thanks,
Peter