public void GetProductWithoutCategory_QuerySyntaxTest()
{
using (TablesDataContext dataContext = new TablesDataContext())
{
Table <Product> table = dataContext.GetTable <Product>();
List <Product> products = table.ToList();
Assert.AreEqual(209, products.Count);
}
}
public void PaginateTest()
{
using (TablesDataContext dataContext = new TablesDataContext())
{
Table <Product> table = dataContext.GetTable <Product>();
List <Product> products = table.ToList();
List <Product> products2 = products.Paginate(10, 0);
Assert.AreEqual(10, products2.Count);
for (int i = 0; i < 10; i++)
{
Assert.AreEqual(products[i], products2[i]);
}
}
}
public bool Add(Product item)
{
try
{
tables.GetTable <Product>().InsertOnSubmit(item);
tables.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public static List <Product> GetProductsByName(string namePart)
{
Table <Product> products = dataContext.GetTable <Product>();
List <Product> result = (from product in products
where product.Name.Contains(namePart)
select product).ToList();
return(result);
}
