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