public void TestSelect_TopWithTies()
{
SelectBuilder builder = new SelectBuilder();
AliasedSource table = builder.AddTable(new Table("Table"));
builder.Top = new Top(new NumericLiteral(5)) { WithTies = true };
builder.AddProjection(table.Column("Column"));
builder.AddOrderBy(new OrderBy(table.Column("Column")));
Formatter formatter = new Formatter();
string commandText = formatter.GetCommandText(builder);
string expected = "SELECT TOP 5 WITH TIES Table.Column FROM Table ORDER BY Table.Column";
Assert.AreEqual(expected, commandText, "The wrong SQL was generated.");
}
public void TestSelect_MultipleOrderByItems()
{
SelectBuilder builder = new SelectBuilder();
AliasedSource table = builder.AddTable(new Table("Table"));
builder.AddProjection(table.Column("Column1"));
builder.AddProjection(table.Column("Column2"));
builder.AddOrderBy(new OrderBy(table.Column("Column1")));
builder.AddOrderBy(new OrderBy(table.Column("Column2")));
Formatter formatter = new Formatter();
string commandText = formatter.GetCommandText(builder);
string expected = "SELECT Table.Column1, Table.Column2 FROM Table ORDER BY Table.Column1, Table.Column2";
Assert.AreEqual(expected, commandText, "The wrong SQL was generated.");
}
public void TestSelect_OrderNullsFirst()
{
SelectBuilder builder = new SelectBuilder();
AliasedSource table = builder.AddTable(new Table("Table"));
builder.AddProjection(table.Column("Column"));
builder.AddOrderBy(new OrderBy(table.Column("Column"), nullPlacement: NullPlacement.First));
Formatter formatter = new Formatter();
string commandText = formatter.GetCommandText(builder);
string expected = "SELECT Table.Column FROM Table ORDER BY Table.Column NULLS FIRST";
Assert.AreEqual(expected, commandText, "The wrong SQL was generated.");
}
