public override string ToSqlExpression(string fieldName, string parameterName)
{
string operatorString = (EqualsValue) ? "=" : "<>";
parameterName = ParameterFormattingService.FormatWithAtSign(parameterName);
return(String.Format(" and {0} {1} {2}", fieldName, operatorString, parameterName));
}
public override Dictionary <string, object> GetDynamicParameters(string parameterName)
{
Dictionary <string, object> output = new Dictionary <string, object>();
parameterName = ParameterFormattingService.FormatWithoutAtSign(parameterName);
output.Add(parameterName, Value);
return(output);
}
public override string ToSqlExpression(string fieldName, string parameterName)
{
string lowOperator, highOperator;
string lowParameterName, highParameterName;
lowOperator = (LowInclusive) ? ">=" : ">";
highOperator = (HighInclusive) ? "<=" : "<";
lowParameterName = ParameterFormattingService.FormatWithAtSign(parameterName + "___LOW");
highParameterName = ParameterFormattingService.FormatWithAtSign(parameterName + "___HIGH");
return(String.Format(" and {0} {1} {2} and {3} {4} {5}",
fieldName, lowOperator, lowParameterName, fieldName, highOperator, highParameterName));
}
public override Dictionary <string, object> GetDynamicParameters(string parameterName)
{
string lowParameterName, highParameterName;
Dictionary <string, object> output;
IEnumerable <T> values;
lowParameterName = ParameterFormattingService.FormatWithoutAtSign(parameterName + "___LOW");
highParameterName = ParameterFormattingService.FormatWithoutAtSign(parameterName + "___HIGH");
values = (IEnumerable <T>)Value;
output = new Dictionary <string, object>();
output.Add(lowParameterName, values.ElementAt(0));
output.Add(highParameterName, values.ElementAt(1));
return(output);
}
public override string ToSqlExpression(string fieldName, string parameterName)
{
parameterName = ParameterFormattingService.FormatWithAtSign(parameterName);
return(String.Format(" and {0} like {1}", fieldName, parameterName));
}
