public Startup(IConfiguration configuration) { Configuration = configuration; using (var db = new MimoDbContext()) { db.Database.EnsureCreated(); db.Database.Migrate(); } }
protected override void Down(MigrationBuilder migrationBuilder) { var seeder = new SeedHelper(); var builder = new DbContextOptionsBuilder <MimoDbContext>() .UseSqlite(seeder.GetConnectionString()); using (var context = new MimoDbContext(builder.Options)) { //todo delete inserted data } }
protected override void Up(MigrationBuilder migrationBuilder) { var seeder = new SeedHelper(); var builder = new DbContextOptionsBuilder <MimoDbContext>() .UseSqlite(seeder.GetConnectionString()); var courses = seeder.GetCourses(); using (var context = new MimoDbContext(builder.Options)) { if (courses != null) { context.Courses.AddRange(courses); } var achievements = seeder.GetAchievements(); if (achievements != null) { context.Achievements.AddRange(achievements); } var users = seeder.GetUsers(); if (users != null) { foreach (var user in users) { if (user.Role == UserRole.Client) { user.Achievements = new List <UserAchievement>(); foreach (var achievement in achievements.Where(x => x.Type != AchievementType.CompleteCourse)) { user.Achievements.Add(new UserAchievement { Achievement = achievement, IsCompleted = false, Progress = 0 }); } } context.Users.Add(user); } } context.SaveChanges(); } }
public CourseRepo(MimoDbContext context) { this.context = context; }
public AchievementRepo(MimoDbContext context) { this.context = context; }