private static void ProvideMissingParameters(System.Data.Common.DbParameterCollection parameters) { SqlParameter userId = new SqlParameter("@UserId", System.Data.SqlDbType.Int); SqlParameter price = new SqlParameter("@Price", System.Data.SqlDbType.Money); SqlParameter contactInfo = new SqlParameter("@ContactInfo", System.Data.SqlDbType.NText); userId.Value = DBNull.Value; price.Value = DBNull.Value; contactInfo.Value = DBNull.Value; parameters.AddRange(new SqlParameter[] { userId, price, contactInfo }); }