//Using Model binding to Bind Data from the database. But databaseInitializer is not sending the data to the database, still replicationg the cause. public IQueryable <ListOfProducts> GetSingleProduct([QueryString("productID")] int?productId) { var _db = new ProductOrderApplication.Models.ProductCategoryContext(); IQueryable <ListOfProducts> query = _db.Products; if (productId.HasValue && productId > 0) { query = query.Where(p => p.ProductID == productId); } else { query = null; } return(query); }
protected void Seed(ProductCategoryContext context) { GetCategories().ForEach(c => context.CategoryOfProducts.Add(c)); GetProducts().ForEach(async p => (await context.Products.ToListAsync()).Add(p)); }