/// <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); }