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."); }