protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { var config = new Microsoft.Extensions.Configuration.ConfigurationBuilder() .SetBasePath(System.IO.Directory.GetCurrentDirectory()) .AddJsonFile(Common.Utility.Const.CONST_FILE_APPSETTING) .Build(); // define the database to use optionsBuilder.UseSqlServer(config.GetConnectionString(Common.Utility.Const.CONST_CHAT_CONNECTION)); }
public void ConfigureServices(IServiceCollection services) { services.AddMvc(); IConfiguration config = new ConfigurationBuilder(). SetBasePath(Directory.GetCurrentDirectory()). AddJsonFile("appsettings.json"). Build(); string connectionString = config.GetConnectionString("ContosoDatabase"); services.AddDbContext<ContosoContext>(options => options.UseSqlServer(connectionString)); }
/// <inheritdoc /> public ApplicationDbContext CreateDbContext(string[] args) { var configuration = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build(); var builder = new DbContextOptionsBuilder <ApplicationDbContext>(); var connectionString = configuration.GetConnectionString(ConfigurationVariables.DefaultConnection); builder.UseSqlServer(connectionString, sqlServerOptions => sqlServerOptions.MigrationsAssembly(ConfigurationVariables.MigrationAssembly)); return(new ApplicationDbContext(builder.Options)); }
public static string GetConnectionString() { string environmentName = Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT"); IConfigurationRoot configuration = new Microsoft.Extensions.Configuration.ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .AddJsonFile($"appsettings.{environmentName}.json", true) .AddEnvironmentVariables().Build(); string connectionString = configuration.GetConnectionString("DefaultConnection"); return(connectionString); }
public WebAppContext CreateDbContext(string[] args) { Microsoft.Extensions.Configuration.IConfigurationRoot configuration = new Microsoft.Extensions.Configuration.ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build(); var builder = new DbContextOptionsBuilder <WebAppContext>(); var connectionString = configuration.GetConnectionString("DefaultConnection"); builder.UseSqlServer(connectionString); return(new WebAppContext(builder.Options)); }