public void ClearSeedData()
{
_context.Database.ExecuteSqlRaw("DELETE FROM SchoolResult");
_context.Database.ExecuteSqlRaw("DELETE FROM SchoolContextual");
_context.Database.ExecuteSqlRaw("DELETE FROM SchoolDetails");
_context.Database.ExecuteSqlRaw("DELETE FROM School");
_context.SaveChanges();
}
public void Setup()
{
//Create an InMemory Sqlite Database for testing
var connection = new InMemorySqliteConnection();
_context = connection._context;
//Create the repository class that will be tested
_repositorySchool = new SchoolPerformanceRepository <School>(_context);
_repositorySchoolResult = new SchoolPerformanceRepository <SchoolResult>(_context);
//Mock data
SetData();
//Remove existing seeded data
ClearSeedData();
//Add and save the mock data to the context
_schools.ForEach(x => _context.School.Add(x));
_schoolResults.ForEach(x => _context.SchoolResult.Add(x));
_context.SaveChanges();
}