public IHttpActionResult PutProduct(int id, Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != product.Id)
{
return(BadRequest());
}
db.Entry(product).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
// This method will cre<ate and seed the database.
public void Initialize(ProductsAppContext context)
{
// Create the database, if it does not already exists. If the database
// already exists, no action is taken (and no effort is made to ensure it
// is compatible with the model for this context).
context.Database.EnsureCreated();
//Look for any TodoItems
if (context.Products.Any())
{
// Delete and re-create the database, if it had already been created.
// You must delete all the tables in the database. We do this, because
// "context.Database.EnsureDeleted()" doesn't work on an Azure SQL
// database with our type of subscription.
// The statements below doesn't work on SqLite. This is the reason why
// we have two database initializer classes (one for SqLite and one for
// SQL Server.
//ERROR context.Database.ExecuteSqlRaw("DROP TABLE Products");
context.Database.EnsureCreated();
}
List <Product> products = new List <Product>
{
new Product {
IsComplete = true, Name = "Use SQL Server"
}
};
context.Products.AddRange(products);
context.SaveChanges();
}
public Product CreateProduct(Product product)
{
Product prod = _context.Products.Add(product).Entity;
_context.SaveChanges();
return(prod);
}
// This method will cre<ate and seed the database.
public void Initialize(ProductsAppContext context)
{
// Delete the database, if it already exists. You need to clean and build
// the solution for this to take effect.
context.Database.EnsureDeleted();
// Create the database, if it does not already exists. If the database
// already exists, no action is taken (and no effort is made to ensure it
// is compatible with the model for this context).
context.Database.EnsureCreated();
List <Product> products = new List <Product>
{
new Product {
IsComplete = true, Name = "Use SqLite"
},
new Product {
IsComplete = false, Name = "Exam project"
}
};
context.Products.AddRange(products);
context.SaveChanges();
}
