/// <summary>
/// Add parameter
/// </summary>
/// <param name="parameter">Parameter item</param>
public void Add(ParameterItem parameter)
{
if (parameter == null)
{
return;
}
if (Parameters.ContainsKey(parameter.Name))
{
Parameters[parameter.Name] = parameter;
}
else
{
Parameters.Add(parameter.Name, parameter);
}
}
/// <summary>
/// Add parameter
/// </summary>
/// <param name="name">Parameter name</param>
/// <param name="value">Parameter value</param>
/// <param name="dbType">DbType</param>
/// <param name="direction">Direction</param>
/// <param name="size">Size</param>
/// <param name="precision">Precision</param>
/// <param name="scale">Scale</param>
public void Add(string name, object value = null, DbType?dbType = null, ParameterDirection?direction = null, int?size = null, byte?precision = null, byte?scale = null)
{
var item = new ParameterItem()
{
Name = name,
Value = value,
ParameterDirection = direction ?? ParameterDirection.Input,
DbType = dbType,
Size = size,
Precision = precision,
Scale = scale
};
Add(item);
}