| public CreateStringParameter ( string parameterName, string value, int length ) : IDataParameter | ||
| parameterName | string | /// The name of the parameter to create. /// |
| value | string | /// The value of the parameter /// |
| length | int | /// The max length of the parameter. If no value is passed, /// a nvarchar(MAX) parameter is created. /// |
| return | IDataParameter | |
public override IDataParameter CreateStringParameter(string parameterName, string value, int? length)
{
if (length.HasValue && value != null)
{
if (value.Length > length)
throw new StringParameterTooLongException(
parameterName, length.Value, value.Length);
}
var parameter = new SqlParameter(parameterName, SqlDbType.NVarChar)
{
Value =
value == null
? DBNull.Value
: (object)value
};
if (length.HasValue)
parameter.Size = length.Value;
return parameter;
}