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