DocumentOrganizer/Diligent.WebAPI.Data/Extensions/ServiceCollection.cs

namespace Diligent.WebAPI.Data.Extensions;

public static class ServiceCollection
{
    public static void ConfigureData(this IServiceCollection services, IConfiguration configuration)
    {
        services.AddDbContext<DatabaseContext>(options =>
        {
            string secret = ""; 
            if (Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT") == "Development")
            {
                options.EnableSensitiveDataLogging();
                secret = Environment.GetEnvironmentVariable("SECRET");
            }
            var connectionString = configuration.GetConnectionString(nameof(Diligent.WebAPI));
            options.UseSqlServer(String.Concat(connectionString, secret));
        });
    }
}