Comments by Merlin Tintin (Top 1 by date)

I think this is better (other you will get an error) :

dr["EffectiveDate"] = effectivedate ?? (object)DBNull.Value;