/// <summary>
/// Generates the text for an Except builder.
/// </summary>
/// <param name="item">The Except builder to generate the text for.</param>
protected internal override void VisitExcept(Except item)
{
visitSelectCombiner(item, "EXCEPT");
}
public void TestSelect_Except()
{
SelectBuilder builder = new SelectBuilder();
builder.AddProjection(new NumericLiteral(1));
Except union = new Except(builder, builder);
Formatter formatter = new Formatter();
string commandText = formatter.GetCommandText(union);
string expected = "SELECT 1 EXCEPT SELECT 1";
Assert.AreEqual(expected, commandText, "The wrong SQL was generated.");
}
/// <summary>
/// Visits an Except builder.
/// </summary>
/// <param name="item">The item to visit.</param>
protected internal virtual void VisitExcept(Except item)
{
}
/// <summary>
/// Visits an Except builder.
/// </summary>
/// <param name="item">The item to visit.</param>
protected internal virtual void VisitExcept(Except item)
{
}
