// 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();
}
// 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();
}
public ProductRepository(ProductsAppContext context)
{
_context = context;
}
