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