I have written an O/R database wrapper that generates some wrapper methods for stored procs it reads from the database.
Now I need to produce some custom wrapper code if an input parameter of a stored proc is defaulted to NULL. The problem is - I get stored proc parameters using:
SqlCommandBuilder.DeriveParameters(command)
and it doesn't bring parameter defaults. Is there any way to look up those defaults? Are they stored anywhere in the database?
BTW, I'm using SQL Server 2008