/// <summary>
/// Generates the text for a NotEqualToQuantifierFilter builder.
/// </summary>
/// <param name="item">The NotEqualToQuantifierFilter builder to generate the text for.</param>
protected internal override void VisitNotEqualToQuantifierFilter(NotEqualToQuantifierFilter item)
{
visitQuantifiedFilter(item, "<>");
}
public void TestSelect_Any_ValueList()
{
SelectBuilder builder = new SelectBuilder();
AliasedSource table = builder.AddTable(new Table("Table"));
builder.AddProjection(table.Column("Column"));
ValueList values = new ValueList(new NumericLiteral(1), new NumericLiteral(2), new NumericLiteral(3));
NotEqualToQuantifierFilter filter = new NotEqualToQuantifierFilter(table.Column("Column"), Quantifier.Any, values);
builder.AddWhere(filter);
Formatter formatter = new Formatter();
string commandText = formatter.GetCommandText(builder);
string expected = "SELECT Table.Column FROM Table WHERE Table.Column <> ANY (1, 2, 3)";
Assert.AreEqual(expected, commandText, "The wrong SQL was generated.");
}
/// <summary>
/// Visits a NotEqualToQuantifierFilter builder.
/// </summary>
/// <param name="item">The item to visit.</param>
protected internal virtual void VisitNotEqualToQuantifierFilter(NotEqualToQuantifierFilter item)
{
}
/// <summary>
/// Visits a NotEqualToQuantifierFilter builder.
/// </summary>
/// <param name="item">The item to visit.</param>
protected internal virtual void VisitNotEqualToQuantifierFilter(NotEqualToQuantifierFilter item)
{
}
