Parameter facets

May 5, 2016 at 10:00 AM

How can I modfy or add custom facets to the function parameters. For e.g. if I need a stored procedure parameter to be of type varchar2 and size 5, I can set the maxlength property on the edmx model. How can I do the same using the code first functions.

Thanks and Regards,
May 6, 2016 at 5:01 PM
Are you sure facets on store function parameters are actually handled? It's been a few years when I looked at this the last time but from what I remember even though you could specify facets in EDMX they were ignored when invoking the stored proc/TVF (I might be wrong though, as I said - it's been a while). I am not sure how things work on Oracle but I think for compatible types SqlServer would just convert the value to the target type. If none of this works and facets are actually taken into account when creating parameters let me know.