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 EFGenericRepository(LabManDBContext dbContext)
{
this.dbContext = dbContext;
this.dbSet = this.dbContext.Set <T>();
this.dbContext.SaveChanges();
}
public EFStudentsRepository(LabManDBContext dbContext) : base(dbContext)
{
base.dependenciesToLoadList = new List <string> {
"Group", "Grades"
};
}
public EFGradesRepository(LabManDBContext dbContext) : base(dbContext)
{
}