/// <summary>
/// Adds a parameter for the stored procedure or the dynamic sql only if condition is true.
/// </summary>
/// <summary>
/// Adds a parameter for the stored procedure or the dynamic sql with a specified direction (e.g. Input, Output)
/// </summary>
public QueryBuilder <TDb, T> AddParameter(string name, object value, QueryParameterDirectionEnum direction)
{
var param = new QueryParameter();
param.Name = name;
param.Value = value;
param.Direction = direction;
_parameters.Add(param);
return(this);
}
public static ParameterDirection MapDirection(QueryParameterDirectionEnum direction)
{
switch (direction)
{
case QueryParameterDirectionEnum.Input: return(ParameterDirection.Input);
case QueryParameterDirectionEnum.Output: return(ParameterDirection.Output);
case QueryParameterDirectionEnum.InputOutput: return(ParameterDirection.InputOutput);
case QueryParameterDirectionEnum.ReturnValue: return(ParameterDirection.ReturnValue);
}
return(ParameterDirection.Input);
}
