public bool InitializeContext(IConfigurationRoot configuration) { string connectionString = configuration.GetConnectionString("LabManDbContext"); var configs = configuration.AsEnumerable(); bool useMySql = false; foreach (KeyValuePair <string, string> config in configs) { if (config.Key.Equals("UseMySql") && config.Value.Equals("Yes")) { useMySql = true; } } var optionsBuilder = new DbContextOptionsBuilder(); if (useMySql) { connectionString = configuration.GetConnectionString("LabManDbContextMysql"); optionsBuilder.UseMySQL(connectionString); } else { optionsBuilder.UseSqlServer(connectionString); } dbContext = new LabManDBContext(optionsBuilder.Options); if (dbContext.Database.EnsureCreated()) { InitTablesWithData(); dbContext.SaveChanges(); } return(true); }
public bool SaveAll() { if (dbContext != null) { dbContext.SaveChanges(); return(true); } return(false); }