/// <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)
{
}
/// <summary>
/// Visits an Intersect builder.
/// </summary>
/// <param name="item">The item to visit.</param>
protected internal virtual void VisitIntersect(Intersect item)
{
}