/// <summary>
/// Creates the db.
/// Data is read from the excel reader and added to the sets Subventions and Participants.
/// </summary>
public void CreateDB()
{
using (var context = new ReligionDatabaseContext())
{
//Clears and delete the database
context.Database.EnsureDeleted();
//Creates the database
context.Database.EnsureCreated();
ExcelReader excel = new ExcelReader();
//Adds every Subvention from the ReadSubventionSource SubventionList into the DatabaseContext
foreach (Subvention s in excel.ReadSubventionSource())
{
context.Subventions.Add(s);
}
//Adds every Participant from the ReadParticipantSource ParticipantList into the DatabaseContext
foreach (Participant p in excel.ReadParticipantSource())
{
context.Participants.Add(p);
}
//Saves all Changes to the database
context.SaveChanges();
}
}
