Set Param.Size when expecting fixed datatype output
I learned it yesterday so probably would like to share this beginner tips.
Example, when you are expecting an output from your stored procedure like below:
(
@varOutput VARCHAR(10) OUTPUT
)
If you do not place the param.size of this @varOutput, you will receive an error like this:
String[1]: The Size Property has an invalid size of 0
So remember to set the size exactly like what you have configured inside your database table.
Cheers.