Monthly Archives: August 2009

Annoying Nulls in SQLParameters

If you read Creating SqlParameters Best Practices you will find the fun you have if you have null values: SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@Required", required), questionCode == null ? new SqlParameter("@Code", DBNull.Value) : new SqlParameter("@Code", questionCode) }; Here is a nice helper function to deal with nulls without having to manually check […]

Read More