public void All_WhereSpecification()
{
var soh = new SalesOrderHeader();
var allRows = soh.All(where : "WHERE CustomerId=@0", args: 30052).ToList();
Assert.AreEqual(4, allRows.Count);
}
public void All_LimitSpecification()
{
var soh = new SalesOrderHeader();
var allRows = soh.All(limit: 10).ToList();
Assert.AreEqual(10, allRows.Count);
}
public void All_NoParameters()
{
var soh = new SalesOrderHeader();
var allRows = soh.All().ToList();
Assert.AreEqual(31465, allRows.Count);
}
public void All_WhereSpecification_ToDataTable()
{
var soh = new SalesOrderHeader();
var allRows = soh.All(where : "WHERE CustomerId=@0", args: 30052).ToList();
Assert.AreEqual(4, allRows.Count);
var allRowsAsDataTable = soh.All(where : "WHERE CustomerId=@0", args: 30052).ToDataTable();
Assert.AreEqual(allRows.Count, allRowsAsDataTable.Rows.Count);
for (int i = 0; i < allRows.Count; i++)
{
Assert.AreEqual(allRows[i].SalesOrderID, allRowsAsDataTable.Rows[i]["SalesOrderId"]);
Assert.AreEqual(30052, allRowsAsDataTable.Rows[i]["CustomerId"]);
}
}
public void All_NoParameters_Streaming()
{
var soh = new SalesOrderHeader();
var allRows = soh.All();
var count = 0;
foreach (var r in allRows)
{
count++;
Assert.AreEqual(26, ((IDictionary <string, object>)r).Count); // # of fields fetched should be 26
}
Assert.AreEqual(31465, count);
}
public void All_WhereSpecification_ColumnsSpecification_LimitSpecification()
{
var soh = new SalesOrderHeader();
var allRows = soh.All(limit: 2, columns: "SalesOrderID as SOID, Status, SalesPersonID", where : "WHERE CustomerId=@0", args: 30052).ToList();
Assert.AreEqual(2, allRows.Count);
var firstRow = (IDictionary <string, object>)allRows[0];
Assert.AreEqual(3, firstRow.Count);
Assert.IsTrue(firstRow.ContainsKey("SOID"));
Assert.IsTrue(firstRow.ContainsKey("Status"));
Assert.IsTrue(firstRow.ContainsKey("SalesPersonID"));
}
public void All_ColumnSpecification()
{
var soh = new SalesOrderHeader();
var allRows = soh.All(columns: "SalesOrderID as SOID, Status, SalesPersonID").ToList();
Assert.AreEqual(31465, allRows.Count);
var firstRow = (IDictionary <string, object>)allRows[0];
Assert.AreEqual(3, firstRow.Count);
Assert.IsTrue(firstRow.ContainsKey("SOID"));
Assert.IsTrue(firstRow.ContainsKey("Status"));
Assert.IsTrue(firstRow.ContainsKey("SalesPersonID"));
}
public void All_WhereSpecification_OrderBySpecification()
{
var soh = new SalesOrderHeader();
var allRows = soh.All(orderBy: "SalesOrderID DESC", where : "WHERE CustomerId=@0", args: 30052).ToList();
Assert.AreEqual(4, allRows.Count);
int previous = int.MaxValue;
foreach (var r in allRows)
{
int current = r.SalesOrderID;
Assert.IsTrue(current <= previous);
previous = current;
}
}
public void All_OrderBySpecification()
{
var soh = new SalesOrderHeader();
var allRows = soh.All(orderBy: "CustomerID DESC").ToList();
Assert.AreEqual(31465, allRows.Count);
int previous = int.MaxValue;
foreach (var r in allRows)
{
int current = r.CustomerID;
Assert.IsTrue(current <= previous);
previous = current;
}
}
