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