http://www.enginpolat.com/aspnet-core-uygulamalarinda-environment-ortam-bilgisine-gore-database-connectionstring-veritabani-baglanti-cumlesi-belirlemek

927

Asp.Net Core uygulamalarında Environment (Ortam) bilgisine göre Database ConnectionString (Veritabanı Bağlantı Cümlesi) belirlemek

AppDataContext.cs

public class AppDataContext : DbContext
{
  public DbSet<Customer> Customers { get; set; }

  public DbSet<Product> Products { get; set; }

  public DbSet<Employee> Employees { get; set; }
}

appsettings.json

{
  "ConnectionStrings": {
    "AppConnectionString": "Data Source={SQLSERVERIP};Initial Catalog={DBNAME-PREFIX};User Id={USERNAME};Password={PASSWORD};"
  }
}

ConfigureServices.cs

public void ConfigureServices(IServiceCollection services)
{
  services.AddDbContextPool<AppDataContext>(options =>
  {
    var builder = new SqlConnectionStringBuilder(Configuration.GetConnectionString("AppConnectionString"));

    builder.InitialCatalog += "_" + HostingEnvironment.EnvironmentName;

    if (HostingEnvironment.IsDevelopment())
    {
      builder.InitialCatalog += "_" + Environment.MachineName;
    }

    var connectionString = builder.ConnectionString;

    options.UseSqlServer(connectionString);
  });
}