public static DbContextOptionsBuilder UseDatabaseFromConfiguration(this DbContextOptionsBuilder options, IConfiguration configuration)
{
var connectionString = configuration.GetConnectionString("DefaultConnection");
var dbType = configuration.GetValue <DbTypes>("DbType");
switch (dbType)
{
case DbTypes.InMemory:
options.UseInMemoryDatabase(connectionString);
break;
case DbTypes.SqlServer:
options.UseSqlServer(connectionString, options => options.MigrationsAssembly("Aguacongas.TheIdServer.Migrations.SqlServer"));
break;
case DbTypes.Sqlite:
options.UseSqlite(connectionString, options => options.MigrationsAssembly("Aguacongas.TheIdServer.Migrations.Sqlite"));
break;
case DbTypes.MySql:
options.UseMySql(connectionString, options => options.MigrationsAssembly("Aguacongas.TheIdServer.Migrations.MySql"));
break;
case DbTypes.Oracle:
options.UseOracle(connectionString, options => options.MigrationsAssembly("Aguacongas.TheIdServer.Migrations.Oracle"));
break;
case DbTypes.PostgreSQL:
options.UseNpgsql(connectionString, options => options.MigrationsAssembly("Aguacongas.TheIdServer.Migrations.PostgreSQL"));
break;
}
return(options);
}