public static void ClearData(EdusentContext context) { context.Database.ExecuteSqlCommand("DELETE FROM [edusent].[Sessions]"); //context.Database.ExecuteSqlCommand("DELETE FROM [edusent].[Students]"); //context.Database.ExecuteSqlCommand("DELETE FROM [edusent].[Teachers]"); context.Database.ExecuteSqlCommand("DELETE FROM [edusent].[Ratings]"); context.Database.ExecuteSqlCommand("DELETE FROM [edusent].[Subjects]"); context.Database.ExecuteSqlCommand("DELETE FROM [dbo].[AspNetUsers]"); }
private static void SeedData(EdusentContext context) { string users = File.ReadAllText(@"./SampleData/dbo.AspNetUsers.data.sql"); //string students = File.ReadAllText(@"./SampleData/dbo.Students.data.sql"); //string teachers = File.ReadAllText(@"./SampleData/dbo.Teachers.data.sql"); string sessions = File.ReadAllText(@"./SampleData/edusent.Sessions.data.sql"); string ratings = File.ReadAllText(@"./SampleData/edusent.Ratings.data.sql"); string subjects = File.ReadAllText(@"./SampleData/edusent.Subjects.data.sql"); context.Database.ExecuteSqlCommand(users); //context.Database.ExecuteSqlCommand(students); //context.Database.ExecuteSqlCommand(teachers); context.Database.ExecuteSqlCommand(sessions); context.Database.ExecuteSqlCommand(ratings); context.Database.ExecuteSqlCommand(subjects); }
public static void InitializeData(EdusentContext context) { context.Database.Migrate(); ClearData(context); SeedData(context); }
public DbInitializer(EdusentContext context) { _context = context; }