Requires DBNull.Value for types with a null value in the form SqlCommandParameter.Value

Question

Which approach is recommended:

void Add(int? value)
{
   command.Parameters.Add("@foo").Value = value;
}

or

void Add(int? value)
{
   command.Parameters.Add("@foo").Value = (object)value ?? DBNull.Value;
}

Answer 1

If you want to pass null to a parameter, you need to pass DBNull.Value, as in your second example.

If you assign nulla parameter as the value, this parameter will not be sent to the procedure, which will cause the procedure to fail (if the parameter is required) or use the default value for the parameter, which may or may not be zero.

Answer 2

It depends on the functionality you want.

null , SqlCommand , . , , , .

DBNull.Value, SqlCommand SQL-.