/// <summary>
/// Generates the text for an EqualToQuantifierFilter builder.
/// </summary>
/// <param name="item">The EqualToQuantifierFilter builder to generate the text for.</param>
protected internal override void VisitEqualToQuantifierFilter(EqualToQuantifierFilter item)
{
visitQuantifiedFilter(item, "=");
}
public void TestSelect_All_Select()
{
SelectBuilder builder = new SelectBuilder();
AliasedSource table = builder.AddTable(new Table("Table"));
builder.AddProjection(table.Column("Column"));
SelectBuilder inner = new SelectBuilder();
inner.AddProjection(new NumericLiteral(1));
EqualToQuantifierFilter filter = new EqualToQuantifierFilter(table.Column("Column"), Quantifier.All, inner);
builder.AddWhere(filter);
Formatter formatter = new Formatter();
string commandText = formatter.GetCommandText(builder);
string expected = "SELECT Table.Column FROM Table WHERE Table.Column = ALL (SELECT 1)";
Assert.AreEqual(expected, commandText, "The wrong SQL was generated.");
}
/// <summary>
/// Generates the text for an EqualToQuantifierFilter builder.
/// </summary>
/// <param name="item">The EqualToQuantifierFilter builder to generate the text for.</param>
protected internal override void VisitEqualToQuantifierFilter(EqualToQuantifierFilter item)
{
visitQuantifiedFilter(item, "=");
}
/// <summary>
/// Visits an EqualToQuantifierFilter builder.
/// </summary>
/// <param name="item">The item to visit.</param>
protected internal virtual void VisitEqualToQuantifierFilter(EqualToQuantifierFilter item)
{
}