LinqToSql stored procedures always makes the paramters nullable. Why?

Question

Hi folks, whenever i drag-n-drop a stored procedure onto my Context canvas, the parameters/arguments for the stored procedure are all nullable.

Why is this? Is it because of how i've declared my parameters inside the stored procudure itself?

Besides manually creating my stored procedure methods in the Context partial class (or drag-n-drop onto canvas, cut from autogen'd code, move to partial class, then remove nullables types) .. is there any way to fix this?

It's really frustrating :(

Answer 1

Parameters to stored procedures are always nullable (there's no equivalent to the "NOT NULL" clause you can add to a column in a table), so Linq to SQL has little choice but to reflect that in its generated methods.

Your best bet is to check (in the proc itself) if NULL has been passed and either raise an error or substitute it with a default value.