/// <summary>
/// Generates the text for a LessThanQuantifierFilter builder.
/// </summary>
/// <param name="item">The LessThanQuantifierFilter builder to generate the text for.</param>
protected internal override void VisitLessThanQuantifierFilter(LessThanQuantifierFilter item)
{
visitQuantifiedFilter(item, "<");
}
public void TestSelect_Some()
{
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));
LessThanQuantifierFilter filter = new LessThanQuantifierFilter(table.Column("Column"), Quantifier.Some, values);
builder.AddWhere(filter);
Formatter formatter = new Formatter();
string commandText = formatter.GetCommandText(builder);
string expected = "SELECT Table.Column FROM Table WHERE Table.Column < SOME (1, 2, 3)";
Assert.AreEqual(expected, commandText, "The wrong SQL was generated.");
}
/// <summary>
/// Visits a LessThanQuantifierFilter builder.
/// </summary>
/// <param name="item">The item to visit.</param>
protected internal virtual void VisitLessThanQuantifierFilter(LessThanQuantifierFilter item)
{
}
/// <summary>
/// Visits a LessThanQuantifierFilter builder.
/// </summary>
/// <param name="item">The item to visit.</param>
protected internal virtual void VisitLessThanQuantifierFilter(LessThanQuantifierFilter item)
{
}
