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; } }