public void TestForQueryForObjectGeneric()
{
Domain.Petshop.Category cat = sqlMap.QueryForObject <Domain.Petshop.Category>("GetFishGeneric", null);
Assert.IsNotNull(cat);
Assert.AreEqual("FISH", cat.Id);
Assert.AreEqual("Fish", cat.Name);
Assert.IsNotNull(cat.GenericProducts, "Expected product list.");
Assert.AreEqual(4, cat.GenericProducts.Count);
Domain.Petshop.Product product = cat.GenericProducts[0];
Assert.AreEqual(2, product.GenericItems.Count);
}
public void TestForQueryForObject()
{
Domain.Petshop.Category cat = (Domain.Petshop.Category)dataMapper.QueryForObject("GetFish", null);
Assert.IsNotNull(cat);
Assert.AreEqual("FISH", cat.Id);
Assert.AreEqual("Fish", cat.Name);
Assert.IsNotNull(cat.Products, "Expected product list.");
Assert.AreEqual(4, cat.Products.Count);
Domain.Petshop.Product product = (Domain.Petshop.Product)cat.Products[0];
Assert.AreEqual(2, product.Items.Count);
}
public void TestJira241()
{
Category myCategory = new Category();
sqlMap.QueryForObject <Category>("GetFishGeneric", null, myCategory);
Assert.IsNotNull(myCategory);
Assert.AreEqual("FISH", myCategory.Id);
Assert.AreEqual("Fish", myCategory.Name);
Assert.IsNotNull(myCategory.GenericProducts, "Expected product list.");
Assert.AreEqual(4, myCategory.GenericProducts.Count);
Domain.Petshop.Product product = myCategory.GenericProducts[0];
Assert.AreEqual(2, product.GenericItems.Count);
}
public void TestGenericFish()
{
IList list = sqlMap.QueryForList("GetFishGeneric", null);
Assert.AreEqual(1, list.Count);
Domain.Petshop.Category cat = (Domain.Petshop.Category)list[0];
Assert.AreEqual("FISH", cat.Id);
Assert.AreEqual("Fish", cat.Name);
Assert.IsNotNull(cat.GenericProducts, "Expected product list.");
Assert.AreEqual(4, cat.GenericProducts.Count);
Domain.Petshop.Product product = cat.GenericProducts[0];
Assert.AreEqual(2, product.GenericItems.Count);
}
public void TestNestedProperties()
{
IList list = dataMapper.QueryForList("GetFish", null);
Assert.AreEqual(1, list.Count);
Domain.Petshop.Category cat = (Domain.Petshop.Category)list[0];
Assert.AreEqual("FISH", cat.Id);
Assert.AreEqual("Fish", cat.Name);
Assert.IsNotNull(cat.Products, "Expected product list.");
Assert.AreEqual(4, cat.Products.Count);
Domain.Petshop.Product product = (Domain.Petshop.Product)cat.Products[0];
Assert.AreEqual(2, product.Items.Count);
}
