public void RunPagingStartToEndSql()
{
//arrange
var writer = new SqlWriter(_table, _sqlType);
var sql = writer.SelectPageStartToEndRowSql();
var dataTable = new DataTable();
Console.WriteLine(sql);
//run generated sql
using (var con = _factory.CreateConnection())
{
con.ConnectionString = _connectionString;
using (var cmd = con.CreateCommand())
{
cmd.CommandText = sql;
var pageSize = cmd.CreateParameter();
pageSize.ParameterName = writer.ParameterName("startRow");
pageSize.Value = 1;
cmd.Parameters.Add(pageSize);
var currentPage = cmd.CreateParameter();
currentPage.ParameterName = writer.ParameterName("endRow");
currentPage.Value = 4;
cmd.Parameters.Add(currentPage);
var da = _factory.CreateDataAdapter();
da.SelectCommand = cmd;
da.Fill(dataTable);
}
}
//assert
Assert.IsTrue(dataTable.Rows.Count > 0, "There should be some categories (this test may fail if database table is empty)");
Assert.IsTrue(dataTable.Rows.Count <= 4, "Should only return the page size (or less)");
foreach (var column in _table.Columns)
{
var name = column.Name;
Assert.IsTrue(dataTable.Columns.Contains(name), "Should retrieve column " + name);
}
}