/// <summary>
/// Adds a parameter.
/// </summary>
/// <param name="sprocParamCondition">The sproc param condition.</param>
/// <returns></returns>
public SprocDbCommand AddParameter(ParameterEqualsCondition sprocParamCondition)
{
if (ReferenceEquals(sprocParamCondition, null))
{
throw new ArgumentNullException("sprocParamCondition");
}
_builder.AddParameterEqualsConditionParameter(sprocParamCondition, _cmd.Parameters);
return(this);
}
internal void AddParameterEqualsConditionParameter(ParameterEqualsCondition condition, DbParameterCollection parameterCollection)
{
var parameter = GetDbProviderFactory().CreateParameter();
parameter.ParameterName = ToParameterName(condition.LeftExpression.ID);
var direction = SprocParameterDirection.Input;
if (condition.LeftExpression.Direction.HasValue)
{
direction = condition.LeftExpression.Direction.Value;
}
parameter.Direction =
(ParameterDirection)
Enum.Parse(typeof(ParameterDirection), direction.ToString());
parameter.Value = (condition.RightExpression == null ?
DBNull.Value : condition.RightExpression.Value);
AdjustParameterProperties(condition.LeftExpression, parameter);
parameterCollection.Add(parameter);
}
