The effect is that you set the int to 0 but get the default SQL value instead (-1). This would probably happen with any default value, not just -1, but I haven't tested others. If you had a default of ...

Nullable guid parameter default value missing in SQL query #1034. Copy link. Description. NikolayYeryomenko. opened on Jun 3, 2018. Issue body actions. I have stored procedure: ...