public void IsValid_SalesPersonIDCheck()
{
var soh = new SalesOrderHeaders();
var toValidate = soh.Single(new { SalesOrderID = 45816 });
// is invalid
Assert.AreEqual(1, soh.IsValid(toValidate).Count);
toValidate = soh.Single(new { SalesOrderID = 45069 });
// is valid
Assert.AreEqual(0, soh.IsValid(toValidate).Count);
}
public void PrimaryKey_Read_Check()
{
var soh = new SalesOrderHeaders();
var toValidate = soh.Single(new { SalesOrderID = 45816 });
Assert.IsTrue(soh.HasPrimaryKey(toValidate));
var pkValue = soh.GetPrimaryKey(toValidate);
Assert.AreEqual(45816, pkValue);
}
public void Single_Key_ThreeColumns()
{
var soh = new SalesOrderHeaders();
SalesOrderHeader singleInstance = soh.Single(43666, columns: "SalesOrderID, SalesOrderNumber, OrderDate");
Assert.AreEqual(43666, singleInstance.SalesOrderID);
Assert.AreEqual("SO43666", singleInstance.SalesOrderNumber);
Assert.AreEqual(new DateTime(2011, 5, 31), singleInstance.OrderDate);
Assert.Null(singleInstance.PurchaseOrderNumber, "");
Assert.AreEqual(singleInstance.CustomerID, 0);
}
public void Single_Key_AllColumns()
{
var soh = new SalesOrderHeaders();
SalesOrderHeader singleInstance = soh.Single(43666);
Assert.AreEqual(43666, singleInstance.SalesOrderID);
Assert.Greater(singleInstance.CustomerID, 0);
Assert.Greater(singleInstance.SalesPersonID, 0);
Assert.Greater(singleInstance.Status, 0);
Assert.AreNotEqual(singleInstance.PurchaseOrderNumber, "");
Assert.Greater(singleInstance.OrderDate, DateTime.MinValue);
}
