public static void Initialize(IConfiguration configuration, IHostingEnvironment env, IServiceProvider svp)
{
var optionsBuilder = new Microsoft.EntityFrameworkCore.DbContextOptionsBuilder();
if (env.IsDevelopment())
{
optionsBuilder.UseSqlServer(configuration.GetConnectionString("DefaultConnection"));
}
else if (env.IsStaging())
{
optionsBuilder.UseSqlServer(configuration.GetConnectionString("DefaultConnection"));
}
else if (env.IsProduction())
{
optionsBuilder.UseSqlServer(configuration.GetConnectionString("DefaultConnection"));
}
var context = new ApplicationContext(optionsBuilder.Options);
if (context.Database.EnsureCreated())
{
IUserMap service = svp.GetService(typeof(IUserMap)) as IUserMap;
new DBInitializeConfig(service).DataTest();
}
}
protected override void OnConfiguring(Microsoft.EntityFrameworkCore.DbContextOptionsBuilder optionsBuilder)
{
if (!optionsBuilder.IsConfigured)
{
optionsBuilder.UseSqlServer(Conexao, p => p.MaxBatchSize(10000));
}
}
public static void AddIdentityServerOperationalDatabase(this Microsoft.EntityFrameworkCore.DbContextOptionsBuilder builder, IConfiguration configuration)
{
string connectionString = configuration.GetConnectionString("IdentityServerOperational");
string providerType = configuration["Database:ProviderType:IdentityServer:Operational"] ?? "sqlite";
string migrationsAssembly = typeof(Startup).GetTypeInfo().Assembly.GetName().Name;
switch (providerType.ToLower())
{
case "mysql":
case "mariadb":
builder.UseMySql(connectionString, ServerVersion.AutoDetect(connectionString), sql => sql.MigrationsAssembly(migrationsAssembly));
break;
case "sqlite":
case "sqlite3":
builder.UseSqlite(connectionString, sql => sql.MigrationsAssembly(migrationsAssembly));
break;
case "sqlserver":
case "mssql":
builder.UseSqlServer(connectionString, sql => sql.MigrationsAssembly(migrationsAssembly));
break;
default:
throw new Exception($"Unknow database provider type: {providerType} - IdentityServer Operational");
}
}
protected override void OnConfiguring(Microsoft.EntityFrameworkCore.DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlServer(@"Data Source = ASUS\ASUS; Initial Catalog = ZNorthwind; Integrated Security = True");
base.OnConfiguring(optionsBuilder);
}
protected override void OnConfiguring(Microsoft.EntityFrameworkCore.DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=BogaDb");
}
protected override void OnConfiguring(Microsoft.EntityFrameworkCore.DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlServer("server=.;database=BoxFesta;trusted_connection=true;");
}
protected override void OnConfiguring
(Microsoft.EntityFrameworkCore.DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlServer
("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=BethanysPieShopDataBase;Data Source=.");
}
protected override void OnConfiguring(Microsoft.EntityFrameworkCore.DbContextOptionsBuilder optionsBuilder)
{
base.OnConfiguring(optionsBuilder);
optionsBuilder.UseSqlServer(@"Password=sql@Master;Persist Security Info=True;User ID=sa;Initial Catalog=HeroApplication;Data Source=DESKTOP-3FTN6K6\SQLEXPRESS");
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
=> optionsBuilder.UseSqlServer("Database=Crunchie", b => b.ApplyConfiguration());
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) => optionsBuilder .UseSqlServer(SqlServerTestStore.CreateConnectionString(StoreName), b => b.ApplyConfiguration()) .UseInternalServiceProvider(_serviceProvider);
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) => optionsBuilder .UseSqlServer(_connection, b => b.ApplyConfiguration()) .UseInternalServiceProvider(_serviceProvider);
