public void getTotalStandardCostByCategoryTest()
{
AdventureWorksLinqToSqlDataContext db = new AdventureWorksLinqToSqlDataContext();
var query = (from category in db.ProductCategories
select category).Take(1);
Assert.AreEqual((decimal)92092.8230, AdventureWorksLinq.getTotalStandardCostByCategory(query.First()));
}
public void getProductNamesByVendorNameTest()
{
List <string> products = AdventureWorksLambda.getProductNamesByVendorName("International");
Assert.AreEqual("Lower Head Race", products[0]);
//Compare with LINQ without Lambda
List <string> expected = AdventureWorksLinq.getProductNamesByVendorName("International");
CollectionAssert.AreEqual(expected, products);
}
public void getNProductsSortedByCategoryTest()
{
List <Product> products = AdventureWorksLinq.getNProductsSortedByCategory(10);
Assert.IsTrue(products.Count == 10);
}
public void getNRecentlyReviewedProductsTest()
{
List <Product> products = AdventureWorksLinq.getNRecentlyReviewedProducts(1);
Assert.IsTrue(products.Count == 1);
}
public void getProductNamesByVendorNameTest()
{
List <string> products = AdventureWorksLinq.getProductNamesByVendorName("International");
Assert.AreEqual("Lower Head Race", products[0]);
}