Serialize SQL parameters
March 15th, 2010
Convert a collection of SQL parameters into a name:value string suitable for writing to a log.
/// <summary>
/// Serializes a collection of
/// <see cref="System.Data.SqlClient.SqlParameter"/>s.
/// </summary>
/// <param name="parameters">
/// The collection of parameters to serialize.
/// </param>
/// <returns>
/// A <see cref="System.String"/> that contains the parameter values.
/// </returns>
public string SerializeSqlParameterCollection(
SqlParameterCollection parameters)
{
StringBuilder sb = new StringBuilder();
foreach (SqlParameter parameter in parameters)
sb.Append(
String.Format("{0}:{1} ",
parameter.ParameterName, parameter.Value));
return sb.ToString();
}
