Check app configuration in a EF migration class

Question

Hello,

I have an web api hosted in Azure that connect to an SQL Database. Any changes to the database schema are done through EF Core Migrations.

In a migration class (Microsoft.EntityFrameworkCore.Migrations.Migration) I would like to access the IConfiguration. I tried to inject it but it fails since this type of classes require parameterless ctor.

I would need this because I am using versioned tables and I need to set HISTORY_RETENTION_PERIOD with values read from app settings.

Angela

Answer 1

Hi, @Angela_HAC. Welcome to Microsoft Q&A. 

If you cannot adjust the constructor parameters and cannot perform dependency injection, you could consider setting IConfiguration as a static property for global access.

Create a static class

public static class GlobalConfiguration
{
        public static IConfiguration? Configuration { get; set; }
}

Assign value in Program or Startup

GlobalConfiguration.Configuration = app.Services.GetService<IConfiguration>();

Get IConfiguration where needed

var _configuration = GlobalConfiguration.Configuration;

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.