public void CTE_WithInnerStatement_InitializesAsCorrectlyFormattedSql()
{
// arrange
var inner_statement = new SqlClause("select * from Table");
// act
var result = SqlClauseBuilder.CTE("X", inner_statement).GetSql();
// assert
result.Should().Be(";with X as (" + Environment.NewLine +
"\tselect * from Table" + Environment.NewLine +
")" + Environment.NewLine);
}
public void CTE_InitializesAsCorrectlyFormattedSql()
{
// arrange
// act
var result = SqlClauseBuilder.CTE("X")
.Add("select * from Table")
.GetSql();
// assert
result.Should().Be(";with X as (" + Environment.NewLine +
"\tselect * from Table" + Environment.NewLine +
")" + Environment.NewLine);
}
