public IAndOr IsNull()
{
if (!string.IsNullOrEmpty(Operand))
{
InnerSql.Append(Operand);
}
InnerSql.Append(" (").Append(WhereColumnName).Append(" IS NULL)");
return(this);
}
public IWithParameter WithParameter(string parameter, object arg)
{
if (Arguments.Count > 0)
{
InnerSql.Append(',');
}
Arguments.Add(new SqlArgument(arg));
InnerSql.Append(parameter);
return(this);
}
public IWhereSingleColumn Where(string column)
{
if (string.IsNullOrEmpty(column))
{
throw new ArgumentException(ExceptionMessages.ArgumentNullOrEmpty.FormatWith("column"));
}
WhereColumnName = SqlCharacters.EscapeSql(column);
if (!AddedWhere)
{
InnerSql.Append(" WHERE");
AddedWhere = true;
}
return(this);
}