Run automatic migration in .net core using ef

Hello Sunny,

Please try to add try catch to check any exception in your method,

public static class MigrationsConfiguration
{
    public static IApplicationBuilder ApplyDbMigrations(this IApplicationBuilder app)
    {
        using var scope = app.ApplicationServices.CreateScope();
        var logger = scope.ServiceProvider.GetRequiredService>();
        var db = scope.ServiceProvider.GetRequiredService();

        try
        {
            logger.LogInformation("Starting database migrations");
            db.Database.Migrate();
            logger.LogInformation("Database migrations completed successfully");
        }
        catch (Exception ex)
        {
            logger.LogError(ex, "An error occurred while applying database migrations");
            throw;
        }

        return app;
    }
}

One more this to check your Configure method is calling this method.

public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
    {
        if (env.IsDevelopment())
        {
            app.UseDeveloperExceptionPage();
        }
        else
        {
            app.UseExceptionHandler("/Home/Error");
            app.UseHsts();
        }

        app.ApplyDbMigrations(); // Apply your DB migration method here so it will execute
}

Amit Mohanty I have checked my program.cs file

Ensure that DbMigrations() is called in the startup process of your application.

var builder = WebApplication.CreateBuilder(args);
// Other service configurations...
var app = builder.Build();
app.DbMigrations();
// Other configurations...
app.Run();