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);
}
