/// <summary>
/// If the DB hasn't yet been seeded, Initialise will add the initial Animal Types so that pets can be correctly added.
/// </summary>
/// <param name="serviceProvider"></param>
public static void Initialise(IServiceProvider serviceProvider)
{
using (var context = new PetRegoDbContext(
serviceProvider.GetRequiredService <DbContextOptions <PetRegoDbContext> >()))
{
context.Database.OpenConnection();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.AnimalTypes ON");
context.Database.EnsureCreated();
if (context.AnimalTypes.Any())
{
return; // We've already seeded the db
}
context.AnimalTypes.AddRange(
new LkpAnimalType {
Id = 1, AnimalType = "Dog", FoodSource = "Bones"
}, // Id = 1,
new LkpAnimalType {
Id = 2, AnimalType = "Cat", FoodSource = "Fish"
}, // Id = 2,
new LkpAnimalType {
Id = 3, AnimalType = "Chicken", FoodSource = "Corn"
}, // Id = 3,
new LkpAnimalType {
Id = 4, AnimalType = "Snake", FoodSource = "Mice"
} // Id = 4.
);
context.SaveChanges();
context.Database.ExecuteSqlCommand($"SET IDENTITY_INSERT dbo.AnimalTypes OFF");
context.Database.CloseConnection();
}
}
public PetRepository(PetRegoDbContext context) : base(context)
{
_dbContext = context;
}
