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