Subscribe RSS FeedI think this is a classic post that everyone should read:
The Most Useful .NET Utility Classes Developers Tend To Reinvent Rather Than Reuse
Archive for August, 2009
The Most Useful .NET Utility Classes Developers Tend To Reinvent Rather Than Reuse
August 7th, 2009 by Sameer | No Comments | Filed in Uncategorized
Annoying Nulls in SQLParameters
August 7th, 2009 by Sameer | 4 Comments | Filed in UncategorizedIf 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 every time.
/// <summary>
/// Return a SqlParameter with DBNull value or value
/// </summary>
/// <param name="key"></param>
/// <param name="value"></param>
/// <returns></returns>
public static SqlParameter NullWrapper(string key, object value)
{
if (value == null)
return new SqlParameter(key, DBNull.Value);
else
return new SqlParameter(key, value);
}
Then you can use it as follows
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("@UserID", userId),
new SqlParameter("@itemNo", itemNo),
General.NullWrapper("@expiryDate", expiryDate) //no need to check if null any more
};
