public void Where_OrderBy_Skip_Take_Select_Sql2008()
{
Database db = new SqlSetForSqlServer.Sql2008Database();
SqlSet set = db.From("products")
.Where("UnitsInStock > 0")
.OrderBy("ProductID")
.Skip(0)
.Take(5)
.Select("ProductName");
SqlBuilder expected = SQL
.SELECT("ProductName")
.FROM(SQL
.SELECT("ROW_NUMBER() OVER (ORDER BY ProductID) AS dbex_rn, __rn.*")
.FROM(SQL
.SELECT("*")
.FROM("products"), "__rn")
.WHERE("UnitsInStock > 0"), "_")
.WHERE("dbex_rn BETWEEN {0} AND {1}", 1, 5)
.ORDER_BY("dbex_rn");
Assert.IsTrue(SqlEquals(set, expected));
}
public void Where_OrderBy_Skip_Take_Select_Sql2008()
{
Database db = new SqlSetForSqlServer.Sql2008Database();
SqlSet set = db.From("products")
.Where("UnitsInStock > 0")
.OrderBy("ProductID")
.Skip(0)
.Take(5)
.Select("ProductName");
SqlBuilder expected = SQL
.SELECT("ProductName")
.FROM(SQL
.SELECT("ROW_NUMBER() OVER (ORDER BY ProductID) AS dbex_rn, __rn.*")
.FROM(SQL
.SELECT("*")
.FROM("products"), "__rn")
.WHERE("UnitsInStock > 0"), "_")
.WHERE("dbex_rn BETWEEN {0} AND {1}", 1, 5)
.ORDER_BY("dbex_rn");
Assert.IsTrue(SqlEquals(set, expected));
}
